﻿using System;
using System.Data;
using Model;
using DBUtility;

namespace DAL
{
     /// <summary>
     /// 数据访问层RESULT_BRAKE_DAL
     /// </summary>
     public class RESULT_BRAKE_DAL
     {
         public RESULT_BRAKE_DAL()
         {
         }


         /// <summary>
         /// 得到最大JCLSH
         /// </summary>
         public string GetMax_JCLSH(string p_strWhere)
         {
             string strResult = "0";
             string strSql = "select max(JCLSH) as m from RESULT_BRAKE";

             if(p_strWhere.Trim().Length > 0)
             {
                 strSql += " where " + p_strWhere;
             }

             DataTable dtTemp = new DataTable();
             DbHelper.GetTable(strSql, ref dtTemp);

             if(dtTemp.Rows.Count>0)
             {
                 if(dtTemp.Rows[0]["m"].ToString().Length>0)
                 {
                     strResult = dtTemp.Rows[0]["m"] == DBNull.Value ? "" : dtTemp.Rows[0]["m"].ToString();
                 }
             }

             dtTemp.Dispose();

             return string.Format("{0:D50}", Convert.ToInt32(strResult) + 1);

          }

          /// <summary>
          /// 得到最大JCLSH
          /// </summary>
          public string GetMax_JCLSH()
          {
              return GetMax_JCLSH("");
          }


          /// <summary>
          /// 判断数据是否存在
          /// </summary>
          public bool Exists(string strJCLSH)
          {
               bool bolResult = false;

               if (strJCLSH == null)
               {
                   return false;
               }

               if (strJCLSH.Length == 0)
               {
                   return false;
               }

               string strSql = "";
               strSql += "select count(1) as c from RESULT_BRAKE";
               strSql += " where ";
               strSql += " JCLSH='"+ strJCLSH +"'";

               DataTable dtTemp = new DataTable();
               DbHelper.GetTable(strSql, ref dtTemp);

               if (dtTemp.Rows.Count > 0)
               {
                   bolResult = Convert.ToInt32(dtTemp.Rows[0]["c"]) > 0;
               }

               dtTemp.Dispose();

               return bolResult;

          }

          /// <summary>
          /// 获取数据总记录数
          /// </summary>
          public int GetRecordCount(string p_strWhere)
          {
              int intResult=0;

              string strSql = "";
              strSql += "select count(1) as c from RESULT_BRAKE";
              if(p_strWhere.Trim().Length > 0)
              {
                 strSql += " where " + p_strWhere;
              }

              DataTable dtTemp = new DataTable();
              DbHelper.GetTable(strSql, ref dtTemp);

              if(dtTemp.Rows.Count>0)
              {
                  intResult=Convert.ToInt32(dtTemp.Rows[0]["c"]);
              }

              dtTemp.Dispose();

              return intResult;
          }

          /// <summary>
          /// 获取数据总记录数
          /// </summary>
          public int GetRecordCount()
          {
              return GetRecordCount("");
          }

          /// <summary>
          /// 获取数据分页总数
           /// </summary>
          public int GetPageCount(string p_strWhere, int p_intPageSize)
          {
              int intResult=0;

              if(p_intPageSize > 0)
              {
                  int intRecordCount = GetRecordCount(p_strWhere);
                  intResult = Convert.ToInt32(Math.Truncate(Convert.ToDecimal(intRecordCount) / Convert.ToDecimal(p_intPageSize)));
                  if (intRecordCount > (intResult * p_intPageSize))
                  {
                       intResult++;
                  }
              }

              if(intResult == 0)
              {
                   intResult++;
              }
              return intResult;
           }

          /// <summary>
          /// 获取数据分页总数
          /// </summary>
          public int GetPageCount(int p_intPageSize)
          {
              return GetPageCount("", p_intPageSize);
          }

          /// <summary>
          /// 添加一条数据 SQL
          /// </summary>
          public string InsertSQL(RESULT_BRAKE model)
          {
              string strFieldSQL = "";
              string strValueSQL = "";

              if(model.Changed("ID") == true && model.ID != null)
              {
                   strFieldSQL += ",ID";
                   strValueSQL += "," + model.ID + "";
              }

              if(model.Changed("ZDYZJCCS") == true && model.ZDYZJCCS != null)
              {
                   strFieldSQL += ",ZDYZJCCS";
                   strValueSQL += ",'" + model.ZDYZJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZDEZJCCS") == true && model.ZDEZJCCS != null)
              {
                   strFieldSQL += ",ZDEZJCCS";
                   strValueSQL += ",'" + model.ZDEZJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZDSZJCCS") == true && model.ZDSZJCCS != null)
              {
                   strFieldSQL += ",ZDSZJCCS";
                   strValueSQL += ",'" + model.ZDSZJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZDSIZJCCS") == true && model.ZDSIZJCCS != null)
              {
                   strFieldSQL += ",ZDSIZJCCS";
                   strValueSQL += ",'" + model.ZDSIZJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZDWZJCCS") == true && model.ZDWZJCCS != null)
              {
                   strFieldSQL += ",ZDWZJCCS";
                   strValueSQL += ",'" + model.ZDWZJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZDLZJCCS") == true && model.ZDLZJCCS != null)
              {
                   strFieldSQL += ",ZDLZJCCS";
                   strValueSQL += ",'" + model.ZDLZJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZDSZDJCCS") == true && model.ZDSZDJCCS != null)
              {
                   strFieldSQL += ",ZDSZDJCCS";
                   strValueSQL += ",'" + model.ZDSZDJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZDZCJCCS") == true && model.ZDZCJCCS != null)
              {
                   strFieldSQL += ",ZDZCJCCS";
                   strValueSQL += ",'" + model.ZDZCJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JCLSH") == true && model.JCLSH != null)
              {
                   strFieldSQL += ",JCLSH";
                   strValueSQL += ",'" + model.JCLSH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZLZ") == true && model.YZZLZ != null)
              {
                   strFieldSQL += ",YZZLZ";
                   strValueSQL += ",'" + model.YZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYLZ") == true && model.YZYLZ != null)
              {
                   strFieldSQL += ",YZYLZ";
                   strValueSQL += ",'" + model.YZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZ") == true && model.YZZZ != null)
              {
                   strFieldSQL += ",YZZZ";
                   strValueSQL += ",'" + model.YZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZLZ") == true && model.EZZLZ != null)
              {
                   strFieldSQL += ",EZZLZ";
                   strValueSQL += ",'" + model.EZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYLZ") == true && model.EZYLZ != null)
              {
                   strFieldSQL += ",EZYLZ";
                   strValueSQL += ",'" + model.EZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZ") == true && model.EZZZ != null)
              {
                   strFieldSQL += ",EZZZ";
                   strValueSQL += ",'" + model.EZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZLZ") == true && model.SZZLZ != null)
              {
                   strFieldSQL += ",SZZLZ";
                   strValueSQL += ",'" + model.SZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZYLZ") == true && model.SZYLZ != null)
              {
                   strFieldSQL += ",SZYLZ";
                   strValueSQL += ",'" + model.SZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZ") == true && model.SZZZ != null)
              {
                   strFieldSQL += ",SZZZ";
                   strValueSQL += ",'" + model.SZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZLZ") == true && model.SIZZLZ != null)
              {
                   strFieldSQL += ",SIZZLZ";
                   strValueSQL += ",'" + model.SIZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZYLZ") == true && model.SIZYLZ != null)
              {
                   strFieldSQL += ",SIZYLZ";
                   strValueSQL += ",'" + model.SIZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZ") == true && model.SIZZZ != null)
              {
                   strFieldSQL += ",SIZZZ";
                   strValueSQL += ",'" + model.SIZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZLZ") == true && model.WZZLZ != null)
              {
                   strFieldSQL += ",WZZLZ";
                   strValueSQL += ",'" + model.WZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZYLZ") == true && model.WZYLZ != null)
              {
                   strFieldSQL += ",WZYLZ";
                   strValueSQL += ",'" + model.WZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZ") == true && model.WZZZ != null)
              {
                   strFieldSQL += ",WZZZ";
                   strValueSQL += ",'" + model.WZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZLZ") == true && model.LZZLZ != null)
              {
                   strFieldSQL += ",LZZLZ";
                   strValueSQL += ",'" + model.LZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZYLZ") == true && model.LZYLZ != null)
              {
                   strFieldSQL += ",LZYLZ";
                   strValueSQL += ",'" + model.LZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZ") == true && model.LZZZ != null)
              {
                   strFieldSQL += ",LZZZ";
                   strValueSQL += ",'" + model.LZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZDTLH") == true && model.YZZDTLH != null)
              {
                   strFieldSQL += ",YZZDTLH";
                   strValueSQL += ",'" + model.YZZDTLH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYDTLH") == true && model.YZYDTLH != null)
              {
                   strFieldSQL += ",YZYDTLH";
                   strValueSQL += ",'" + model.YZYDTLH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZDTLH") == true && model.YZDTLH != null)
              {
                   strFieldSQL += ",YZDTLH";
                   strValueSQL += ",'" + model.YZDTLH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZDTLH") == true && model.EZZDTLH != null)
              {
                   strFieldSQL += ",EZZDTLH";
                   strValueSQL += ",'" + model.EZZDTLH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYDTLH") == true && model.EZYDTLH != null)
              {
                   strFieldSQL += ",EZYDTLH";
                   strValueSQL += ",'" + model.EZYDTLH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZDTLH") == true && model.EZDTLH != null)
              {
                   strFieldSQL += ",EZDTLH";
                   strValueSQL += ",'" + model.EZDTLH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCZLZ") == true && model.ZCZLZ != null)
              {
                   strFieldSQL += ",ZCZLZ";
                   strValueSQL += ",'" + model.ZCZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCYLZ") == true && model.ZCYLZ != null)
              {
                   strFieldSQL += ",ZCYLZ";
                   strValueSQL += ",'" + model.ZCYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCZZ") == true && model.ZCZZ != null)
              {
                   strFieldSQL += ",ZCZZ";
                   strValueSQL += ",'" + model.ZCZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZZL") == true && model.YZZZZL != null)
              {
                   strFieldSQL += ",YZZZZL";
                   strValueSQL += ",'" + model.YZZZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYZZL") == true && model.YZYZZL != null)
              {
                   strFieldSQL += ",YZYZZL";
                   strValueSQL += ",'" + model.YZYZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZZLV") == true && model.YZZZZLV != null)
              {
                   strFieldSQL += ",YZZZZLV";
                   strValueSQL += ",'" + model.YZZZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYZZLV") == true && model.YZYZZLV != null)
              {
                   strFieldSQL += ",YZYZZLV";
                   strValueSQL += ",'" + model.YZYZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZZL_PD") == true && model.YZZZZL_PD != null)
              {
                   strFieldSQL += ",YZZZZL_PD";
                   strValueSQL += ",'" + model.YZZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYZZL_PD") == true && model.YZYZZL_PD != null)
              {
                   strFieldSQL += ",YZYZZL_PD";
                   strValueSQL += ",'" + model.YZYZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZL_PD") == true && model.YZZZL_PD != null)
              {
                   strFieldSQL += ",YZZZL_PD";
                   strValueSQL += ",'" + model.YZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZZL") == true && model.EZZZZL != null)
              {
                   strFieldSQL += ",EZZZZL";
                   strValueSQL += ",'" + model.EZZZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYZZL") == true && model.EZYZZL != null)
              {
                   strFieldSQL += ",EZYZZL";
                   strValueSQL += ",'" + model.EZYZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZZLV") == true && model.EZZZZLV != null)
              {
                   strFieldSQL += ",EZZZZLV";
                   strValueSQL += ",'" + model.EZZZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYZZLV") == true && model.EZYZZLV != null)
              {
                   strFieldSQL += ",EZYZZLV";
                   strValueSQL += ",'" + model.EZYZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZZL_PD") == true && model.EZZZZL_PD != null)
              {
                   strFieldSQL += ",EZZZZL_PD";
                   strValueSQL += ",'" + model.EZZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYZZL_PD") == true && model.EZYZZL_PD != null)
              {
                   strFieldSQL += ",EZYZZL_PD";
                   strValueSQL += ",'" + model.EZYZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZL_PD") == true && model.EZZZL_PD != null)
              {
                   strFieldSQL += ",EZZZL_PD";
                   strValueSQL += ",'" + model.EZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZZL") == true && model.SZZZZL != null)
              {
                   strFieldSQL += ",SZZZZL";
                   strValueSQL += ",'" + model.SZZZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZYZZL") == true && model.SZYZZL != null)
              {
                   strFieldSQL += ",SZYZZL";
                   strValueSQL += ",'" + model.SZYZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZZLV") == true && model.SZZZZLV != null)
              {
                   strFieldSQL += ",SZZZZLV";
                   strValueSQL += ",'" + model.SZZZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZYZZLV") == true && model.SZYZZLV != null)
              {
                   strFieldSQL += ",SZYZZLV";
                   strValueSQL += ",'" + model.SZYZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZZL_PD") == true && model.SZZZZL_PD != null)
              {
                   strFieldSQL += ",SZZZZL_PD";
                   strValueSQL += ",'" + model.SZZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZYZZL_PD") == true && model.SZYZZL_PD != null)
              {
                   strFieldSQL += ",SZYZZL_PD";
                   strValueSQL += ",'" + model.SZYZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZL_PD") == true && model.SZZZL_PD != null)
              {
                   strFieldSQL += ",SZZZL_PD";
                   strValueSQL += ",'" + model.SZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZZL") == true && model.SIZZZZL != null)
              {
                   strFieldSQL += ",SIZZZZL";
                   strValueSQL += ",'" + model.SIZZZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZYZZL") == true && model.SIZYZZL != null)
              {
                   strFieldSQL += ",SIZYZZL";
                   strValueSQL += ",'" + model.SIZYZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZZLV") == true && model.SIZZZZLV != null)
              {
                   strFieldSQL += ",SIZZZZLV";
                   strValueSQL += ",'" + model.SIZZZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZYZZLV") == true && model.SIZYZZLV != null)
              {
                   strFieldSQL += ",SIZYZZLV";
                   strValueSQL += ",'" + model.SIZYZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZZL_PD") == true && model.SIZZZZL_PD != null)
              {
                   strFieldSQL += ",SIZZZZL_PD";
                   strValueSQL += ",'" + model.SIZZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZYZZL_PD") == true && model.SIZYZZL_PD != null)
              {
                   strFieldSQL += ",SIZYZZL_PD";
                   strValueSQL += ",'" + model.SIZYZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZL_PD") == true && model.SIZZZL_PD != null)
              {
                   strFieldSQL += ",SIZZZL_PD";
                   strValueSQL += ",'" + model.SIZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZZL") == true && model.WZZZZL != null)
              {
                   strFieldSQL += ",WZZZZL";
                   strValueSQL += ",'" + model.WZZZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZYZZL") == true && model.WZYZZL != null)
              {
                   strFieldSQL += ",WZYZZL";
                   strValueSQL += ",'" + model.WZYZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZZLV") == true && model.WZZZZLV != null)
              {
                   strFieldSQL += ",WZZZZLV";
                   strValueSQL += ",'" + model.WZZZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZYZZLV") == true && model.WZYZZLV != null)
              {
                   strFieldSQL += ",WZYZZLV";
                   strValueSQL += ",'" + model.WZYZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZZL_PD") == true && model.WZZZZL_PD != null)
              {
                   strFieldSQL += ",WZZZZL_PD";
                   strValueSQL += ",'" + model.WZZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZYZZL_PD") == true && model.WZYZZL_PD != null)
              {
                   strFieldSQL += ",WZYZZL_PD";
                   strValueSQL += ",'" + model.WZYZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZL_PD") == true && model.WZZZL_PD != null)
              {
                   strFieldSQL += ",WZZZL_PD";
                   strValueSQL += ",'" + model.WZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZZL") == true && model.LZZZZL != null)
              {
                   strFieldSQL += ",LZZZZL";
                   strValueSQL += ",'" + model.LZZZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZYZZL") == true && model.LZYZZL != null)
              {
                   strFieldSQL += ",LZYZZL";
                   strValueSQL += ",'" + model.LZYZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZZLV") == true && model.LZZZZLV != null)
              {
                   strFieldSQL += ",LZZZZLV";
                   strValueSQL += ",'" + model.LZZZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZYZZLV") == true && model.LZYZZLV != null)
              {
                   strFieldSQL += ",LZYZZLV";
                   strValueSQL += ",'" + model.LZYZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZZL_PD") == true && model.LZZZZL_PD != null)
              {
                   strFieldSQL += ",LZZZZL_PD";
                   strValueSQL += ",'" + model.LZZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZYZZL_PD") == true && model.LZYZZL_PD != null)
              {
                   strFieldSQL += ",LZYZZL_PD";
                   strValueSQL += ",'" + model.LZYZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZL_PD") == true && model.LZZZL_PD != null)
              {
                   strFieldSQL += ",LZZZL_PD";
                   strValueSQL += ",'" + model.LZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZDCZD") == true && model.YZZZDCZD != null)
              {
                   strFieldSQL += ",YZZZDCZD";
                   strValueSQL += ",'" + model.YZZZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYZDCZD") == true && model.YZYZDCZD != null)
              {
                   strFieldSQL += ",YZYZDCZD";
                   strValueSQL += ",'" + model.YZYZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZBPHLV") == true && model.YZBPHLV != null)
              {
                   strFieldSQL += ",YZBPHLV";
                   strValueSQL += ",'" + model.YZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZBPHLV_PD") == true && model.YZBPHLV_PD != null)
              {
                   strFieldSQL += ",YZBPHLV_PD";
                   strValueSQL += ",'" + model.YZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZDCZD") == true && model.EZZZDCZD != null)
              {
                   strFieldSQL += ",EZZZDCZD";
                   strValueSQL += ",'" + model.EZZZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYZDCZD") == true && model.EZYZDCZD != null)
              {
                   strFieldSQL += ",EZYZDCZD";
                   strValueSQL += ",'" + model.EZYZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZBPHLV") == true && model.EZBPHLV != null)
              {
                   strFieldSQL += ",EZBPHLV";
                   strValueSQL += ",'" + model.EZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZBPHLV_PD") == true && model.EZBPHLV_PD != null)
              {
                   strFieldSQL += ",EZBPHLV_PD";
                   strValueSQL += ",'" + model.EZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZDCZD") == true && model.SZZZDCZD != null)
              {
                   strFieldSQL += ",SZZZDCZD";
                   strValueSQL += ",'" + model.SZZZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZYZDCZD") == true && model.SZYZDCZD != null)
              {
                   strFieldSQL += ",SZYZDCZD";
                   strValueSQL += ",'" + model.SZYZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZBPHLV") == true && model.SZBPHLV != null)
              {
                   strFieldSQL += ",SZBPHLV";
                   strValueSQL += ",'" + model.SZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZBPHLV_PD") == true && model.SZBPHLV_PD != null)
              {
                   strFieldSQL += ",SZBPHLV_PD";
                   strValueSQL += ",'" + model.SZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZDCZD") == true && model.SIZZZDCZD != null)
              {
                   strFieldSQL += ",SIZZZDCZD";
                   strValueSQL += ",'" + model.SIZZZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZYZDCZD") == true && model.SIZYZDCZD != null)
              {
                   strFieldSQL += ",SIZYZDCZD";
                   strValueSQL += ",'" + model.SIZYZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZBPHLV") == true && model.SIZBPHLV != null)
              {
                   strFieldSQL += ",SIZBPHLV";
                   strValueSQL += ",'" + model.SIZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZBPHLV_PD") == true && model.SIZBPHLV_PD != null)
              {
                   strFieldSQL += ",SIZBPHLV_PD";
                   strValueSQL += ",'" + model.SIZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZDCZD") == true && model.WZZZDCZD != null)
              {
                   strFieldSQL += ",WZZZDCZD";
                   strValueSQL += ",'" + model.WZZZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZYZDCZD") == true && model.WZYZDCZD != null)
              {
                   strFieldSQL += ",WZYZDCZD";
                   strValueSQL += ",'" + model.WZYZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZBPHLV") == true && model.WZBPHLV != null)
              {
                   strFieldSQL += ",WZBPHLV";
                   strValueSQL += ",'" + model.WZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZBPHLV_PD") == true && model.WZBPHLV_PD != null)
              {
                   strFieldSQL += ",WZBPHLV_PD";
                   strValueSQL += ",'" + model.WZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZDCZD") == true && model.LZZZDCZD != null)
              {
                   strFieldSQL += ",LZZZDCZD";
                   strValueSQL += ",'" + model.LZZZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZYZDCZD") == true && model.LZYZDCZD != null)
              {
                   strFieldSQL += ",LZYZDCZD";
                   strValueSQL += ",'" + model.LZYZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZBPHLV") == true && model.LZBPHLV != null)
              {
                   strFieldSQL += ",LZBPHLV";
                   strValueSQL += ",'" + model.LZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZBPHLV_PD") == true && model.LZBPHLV_PD != null)
              {
                   strFieldSQL += ",LZBPHLV_PD";
                   strValueSQL += ",'" + model.LZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZDZDL") == true && model.YZZZDZDL != null)
              {
                   strFieldSQL += ",YZZZDZDL";
                   strValueSQL += ",'" + model.YZZZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYZDZDL") == true && model.YZYZDZDL != null)
              {
                   strFieldSQL += ",YZYZDZDL";
                   strValueSQL += ",'" + model.YZYZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZDLV") == true && model.YZZDLV != null)
              {
                   strFieldSQL += ",YZZDLV";
                   strValueSQL += ",'" + model.YZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZDLV_PD") == true && model.YZZDLV_PD != null)
              {
                   strFieldSQL += ",YZZDLV_PD";
                   strValueSQL += ",'" + model.YZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZDZDL") == true && model.EZZZDZDL != null)
              {
                   strFieldSQL += ",EZZZDZDL";
                   strValueSQL += ",'" + model.EZZZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYZDZDL") == true && model.EZYZDZDL != null)
              {
                   strFieldSQL += ",EZYZDZDL";
                   strValueSQL += ",'" + model.EZYZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZDLV") == true && model.EZZDLV != null)
              {
                   strFieldSQL += ",EZZDLV";
                   strValueSQL += ",'" + model.EZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZDLV_PD") == true && model.EZZDLV_PD != null)
              {
                   strFieldSQL += ",EZZDLV_PD";
                   strValueSQL += ",'" + model.EZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZDZDL") == true && model.SZZZDZDL != null)
              {
                   strFieldSQL += ",SZZZDZDL";
                   strValueSQL += ",'" + model.SZZZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZYZDZDL") == true && model.SZYZDZDL != null)
              {
                   strFieldSQL += ",SZYZDZDL";
                   strValueSQL += ",'" + model.SZYZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZDLV") == true && model.SZZDLV != null)
              {
                   strFieldSQL += ",SZZDLV";
                   strValueSQL += ",'" + model.SZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZDLV_PD") == true && model.SZZDLV_PD != null)
              {
                   strFieldSQL += ",SZZDLV_PD";
                   strValueSQL += ",'" + model.SZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZDZDL") == true && model.SIZZZDZDL != null)
              {
                   strFieldSQL += ",SIZZZDZDL";
                   strValueSQL += ",'" + model.SIZZZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZYZDZDL") == true && model.SIZYZDZDL != null)
              {
                   strFieldSQL += ",SIZYZDZDL";
                   strValueSQL += ",'" + model.SIZYZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZDLV") == true && model.SIZZDLV != null)
              {
                   strFieldSQL += ",SIZZDLV";
                   strValueSQL += ",'" + model.SIZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZDLV_PD") == true && model.SIZZDLV_PD != null)
              {
                   strFieldSQL += ",SIZZDLV_PD";
                   strValueSQL += ",'" + model.SIZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZDZDL") == true && model.WZZZDZDL != null)
              {
                   strFieldSQL += ",WZZZDZDL";
                   strValueSQL += ",'" + model.WZZZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZYZDZDL") == true && model.WZYZDZDL != null)
              {
                   strFieldSQL += ",WZYZDZDL";
                   strValueSQL += ",'" + model.WZYZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZDLV") == true && model.WZZDLV != null)
              {
                   strFieldSQL += ",WZZDLV";
                   strValueSQL += ",'" + model.WZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZDLV_PD") == true && model.WZZDLV_PD != null)
              {
                   strFieldSQL += ",WZZDLV_PD";
                   strValueSQL += ",'" + model.WZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZDZDL") == true && model.LZZZDZDL != null)
              {
                   strFieldSQL += ",LZZZDZDL";
                   strValueSQL += ",'" + model.LZZZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZYZDZDL") == true && model.LZYZDZDL != null)
              {
                   strFieldSQL += ",LZYZDZDL";
                   strValueSQL += ",'" + model.LZYZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZDLV") == true && model.LZZDLV != null)
              {
                   strFieldSQL += ",LZZDLV";
                   strValueSQL += ",'" + model.LZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZDLV_PD") == true && model.LZZDLV_PD != null)
              {
                   strFieldSQL += ",LZZDLV_PD";
                   strValueSQL += ",'" + model.LZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZSZDL") == true && model.YZZSZDL != null)
              {
                   strFieldSQL += ",YZZSZDL";
                   strValueSQL += ",'" + model.YZZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYSZDL") == true && model.YZYSZDL != null)
              {
                   strFieldSQL += ",YZYSZDL";
                   strValueSQL += ",'" + model.YZYSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZSZDL") == true && model.YZSZDL != null)
              {
                   strFieldSQL += ",YZSZDL";
                   strValueSQL += ",'" + model.YZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZSZDL") == true && model.EZZSZDL != null)
              {
                   strFieldSQL += ",EZZSZDL";
                   strValueSQL += ",'" + model.EZZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYSZDL") == true && model.EZYSZDL != null)
              {
                   strFieldSQL += ",EZYSZDL";
                   strValueSQL += ",'" + model.EZYSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZSZDL") == true && model.EZSZDL != null)
              {
                   strFieldSQL += ",EZSZDL";
                   strValueSQL += ",'" + model.EZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZSZDL") == true && model.SZZSZDL != null)
              {
                   strFieldSQL += ",SZZSZDL";
                   strValueSQL += ",'" + model.SZZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZYSZDL") == true && model.SZYSZDL != null)
              {
                   strFieldSQL += ",SZYSZDL";
                   strValueSQL += ",'" + model.SZYSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZSZDL") == true && model.SZSZDL != null)
              {
                   strFieldSQL += ",SZSZDL";
                   strValueSQL += ",'" + model.SZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZSZDL") == true && model.SIZZSZDL != null)
              {
                   strFieldSQL += ",SIZZSZDL";
                   strValueSQL += ",'" + model.SIZZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZYSZDL") == true && model.SIZYSZDL != null)
              {
                   strFieldSQL += ",SIZYSZDL";
                   strValueSQL += ",'" + model.SIZYSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZSZDL") == true && model.SIZSZDL != null)
              {
                   strFieldSQL += ",SIZSZDL";
                   strValueSQL += ",'" + model.SIZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZSZDL") == true && model.WZZSZDL != null)
              {
                   strFieldSQL += ",WZZSZDL";
                   strValueSQL += ",'" + model.WZZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZYSZDL") == true && model.WZYSZDL != null)
              {
                   strFieldSQL += ",WZYSZDL";
                   strValueSQL += ",'" + model.WZYSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZSZDL") == true && model.WZSZDL != null)
              {
                   strFieldSQL += ",WZSZDL";
                   strValueSQL += ",'" + model.WZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZSZDL") == true && model.LZZSZDL != null)
              {
                   strFieldSQL += ",LZZSZDL";
                   strValueSQL += ",'" + model.LZZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZYSZDL") == true && model.LZYSZDL != null)
              {
                   strFieldSQL += ",LZYSZDL";
                   strValueSQL += ",'" + model.LZYSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZSZDL") == true && model.LZSZDL != null)
              {
                   strFieldSQL += ",LZSZDL";
                   strValueSQL += ",'" + model.LZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZZSZDL") == true && model.ZZSZDL != null)
              {
                   strFieldSQL += ",ZZSZDL";
                   strValueSQL += ",'" + model.ZZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZYSZDL") == true && model.ZYSZDL != null)
              {
                   strFieldSQL += ",ZYSZDL";
                   strValueSQL += ",'" + model.ZYSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZSZDL") == true && model.ZSZDL != null)
              {
                   strFieldSQL += ",ZSZDL";
                   strValueSQL += ",'" + model.ZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCSZDLV") == true && model.ZCSZDLV != null)
              {
                   strFieldSQL += ",ZCSZDLV";
                   strValueSQL += ",'" + model.ZCSZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZDLV_PD") == true && model.SZDLV_PD != null)
              {
                   strFieldSQL += ",SZDLV_PD";
                   strValueSQL += ",'" + model.SZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCZDL") == true && model.ZCZDL != null)
              {
                   strFieldSQL += ",ZCZDL";
                   strValueSQL += ",'" + model.ZCZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCZDLV") == true && model.ZCZDLV != null)
              {
                   strFieldSQL += ",ZCZDLV";
                   strValueSQL += ",'" + model.ZCZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCZDLV_PD") == true && model.ZCZDLV_PD != null)
              {
                   strFieldSQL += ",ZCZDLV_PD";
                   strValueSQL += ",'" + model.ZCZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZJZZZ") == true && model.YZJZZZ != null)
              {
                   strFieldSQL += ",YZJZZZ";
                   strValueSQL += ",'" + model.YZJZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZJZZZ") == true && model.EZJZZZ != null)
              {
                   strFieldSQL += ",EZJZZZ";
                   strValueSQL += ",'" + model.EZJZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZJZZZ") == true && model.SZJZZZ != null)
              {
                   strFieldSQL += ",SZJZZZ";
                   strValueSQL += ",'" + model.SZJZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZJZZZ") == true && model.SIZJZZZ != null)
              {
                   strFieldSQL += ",SIZJZZZ";
                   strValueSQL += ",'" + model.SIZJZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZJZZZ") == true && model.WZJZZZ != null)
              {
                   strFieldSQL += ",WZJZZZ";
                   strValueSQL += ",'" + model.WZJZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZJZZZ") == true && model.LZJZZZ != null)
              {
                   strFieldSQL += ",LZJZZZ";
                   strValueSQL += ",'" + model.LZJZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZJZZDLV") == true && model.YZJZZDLV != null)
              {
                   strFieldSQL += ",YZJZZDLV";
                   strValueSQL += ",'" + model.YZJZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZJZZDLV_PD") == true && model.YZJZZDLV_PD != null)
              {
                   strFieldSQL += ",YZJZZDLV_PD";
                   strValueSQL += ",'" + model.YZJZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZJZZDLV") == true && model.EZJZZDLV != null)
              {
                   strFieldSQL += ",EZJZZDLV";
                   strValueSQL += ",'" + model.EZJZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZJZZDLV_PD") == true && model.EZJZZDLV_PD != null)
              {
                   strFieldSQL += ",EZJZZDLV_PD";
                   strValueSQL += ",'" + model.EZJZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZJZZDLV") == true && model.SZJZZDLV != null)
              {
                   strFieldSQL += ",SZJZZDLV";
                   strValueSQL += ",'" + model.SZJZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZJZZDLV_PD") == true && model.SZJZZDLV_PD != null)
              {
                   strFieldSQL += ",SZJZZDLV_PD";
                   strValueSQL += ",'" + model.SZJZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZJZZDLV") == true && model.SIZJZZDLV != null)
              {
                   strFieldSQL += ",SIZJZZDLV";
                   strValueSQL += ",'" + model.SIZJZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZJZZDLV_PD") == true && model.SIZJZZDLV_PD != null)
              {
                   strFieldSQL += ",SIZJZZDLV_PD";
                   strValueSQL += ",'" + model.SIZJZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZJZZDLV") == true && model.WZJZZDLV != null)
              {
                   strFieldSQL += ",WZJZZDLV";
                   strValueSQL += ",'" + model.WZJZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZJZZDLV_PD") == true && model.WZJZZDLV_PD != null)
              {
                   strFieldSQL += ",WZJZZDLV_PD";
                   strValueSQL += ",'" + model.WZJZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZJZZDLV") == true && model.LZJZZDLV != null)
              {
                   strFieldSQL += ",LZJZZDLV";
                   strValueSQL += ",'" + model.LZJZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZJZZDLV_PD") == true && model.LZJZZDLV_PD != null)
              {
                   strFieldSQL += ",LZJZZDLV_PD";
                   strValueSQL += ",'" + model.LZJZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZJZBPHLV") == true && model.YZJZBPHLV != null)
              {
                   strFieldSQL += ",YZJZBPHLV";
                   strValueSQL += ",'" + model.YZJZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZJZBPHLV_PD") == true && model.YZJZBPHLV_PD != null)
              {
                   strFieldSQL += ",YZJZBPHLV_PD";
                   strValueSQL += ",'" + model.YZJZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZJZBPHLV") == true && model.EZJZBPHLV != null)
              {
                   strFieldSQL += ",EZJZBPHLV";
                   strValueSQL += ",'" + model.EZJZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZJZBPHLV_PD") == true && model.EZJZBPHLV_PD != null)
              {
                   strFieldSQL += ",EZJZBPHLV_PD";
                   strValueSQL += ",'" + model.EZJZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZJZBPHLV") == true && model.SZJZBPHLV != null)
              {
                   strFieldSQL += ",SZJZBPHLV";
                   strValueSQL += ",'" + model.SZJZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZJZBPHLV_PD") == true && model.SZJZBPHLV_PD != null)
              {
                   strFieldSQL += ",SZJZBPHLV_PD";
                   strValueSQL += ",'" + model.SZJZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZJZBPHLV") == true && model.SIZJZBPHLV != null)
              {
                   strFieldSQL += ",SIZJZBPHLV";
                   strValueSQL += ",'" + model.SIZJZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZJZBPHLV_PD") == true && model.SIZJZBPHLV_PD != null)
              {
                   strFieldSQL += ",SIZJZBPHLV_PD";
                   strValueSQL += ",'" + model.SIZJZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZJZBPHLV") == true && model.WZJZBPHLV != null)
              {
                   strFieldSQL += ",WZJZBPHLV";
                   strValueSQL += ",'" + model.WZJZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZJZBPHLV_PD") == true && model.WZJZBPHLV_PD != null)
              {
                   strFieldSQL += ",WZJZBPHLV_PD";
                   strValueSQL += ",'" + model.WZJZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZJZBPHLV") == true && model.LZJZBPHLV != null)
              {
                   strFieldSQL += ",LZJZBPHLV";
                   strValueSQL += ",'" + model.LZJZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZJZBPHLV_PD") == true && model.LZJZBPHLV_PD != null)
              {
                   strFieldSQL += ",LZJZBPHLV_PD";
                   strValueSQL += ",'" + model.LZJZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZDZ_PD") == true && model.YZZDZ_PD != null)
              {
                   strFieldSQL += ",YZZDZ_PD";
                   strValueSQL += ",'" + model.YZZDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZDZ_PD") == true && model.EZZDZ_PD != null)
              {
                   strFieldSQL += ",EZZDZ_PD";
                   strValueSQL += ",'" + model.EZZDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZDZ_PD") == true && model.SZZDZ_PD != null)
              {
                   strFieldSQL += ",SZZDZ_PD";
                   strValueSQL += ",'" + model.SZZDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZDZ_PD") == true && model.SIZZDZ_PD != null)
              {
                   strFieldSQL += ",SIZZDZ_PD";
                   strValueSQL += ",'" + model.SIZZDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZDZ_PD") == true && model.WZZDZ_PD != null)
              {
                   strFieldSQL += ",WZZDZ_PD";
                   strValueSQL += ",'" + model.WZZDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZDZ_PD") == true && model.LZZDZ_PD != null)
              {
                   strFieldSQL += ",LZZDZ_PD";
                   strValueSQL += ",'" + model.LZZDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZLVXZBZ") == true && model.YZZZLVXZBZ != null)
              {
                   strFieldSQL += ",YZZZLVXZBZ";
                   strValueSQL += ",'" + model.YZZZLVXZBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZLVXZBZ") == true && model.EZZZLVXZBZ != null)
              {
                   strFieldSQL += ",EZZZLVXZBZ";
                   strValueSQL += ",'" + model.EZZZLVXZBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZLVXZBZ") == true && model.SZZZLVXZBZ != null)
              {
                   strFieldSQL += ",SZZZLVXZBZ";
                   strValueSQL += ",'" + model.SZZZLVXZBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZLVXZBZ") == true && model.SIZZZLVXZBZ != null)
              {
                   strFieldSQL += ",SIZZZLVXZBZ";
                   strValueSQL += ",'" + model.SIZZZLVXZBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZLVXZBZ") == true && model.WZZZLVXZBZ != null)
              {
                   strFieldSQL += ",WZZZLVXZBZ";
                   strValueSQL += ",'" + model.WZZZLVXZBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZLVXZBZ") == true && model.LZZZLVXZBZ != null)
              {
                   strFieldSQL += ",LZZZLVXZBZ";
                   strValueSQL += ",'" + model.LZZZLVXZBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZBPHLVBZ") == true && model.YZBPHLVBZ != null)
              {
                   strFieldSQL += ",YZBPHLVBZ";
                   strValueSQL += ",'" + model.YZBPHLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZBPHLVBZ") == true && model.EZBPHLVBZ != null)
              {
                   strFieldSQL += ",EZBPHLVBZ";
                   strValueSQL += ",'" + model.EZBPHLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZBPHLVBZ") == true && model.SZBPHLVBZ != null)
              {
                   strFieldSQL += ",SZBPHLVBZ";
                   strValueSQL += ",'" + model.SZBPHLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZBPHLVBZ") == true && model.SIZBPHLVBZ != null)
              {
                   strFieldSQL += ",SIZBPHLVBZ";
                   strValueSQL += ",'" + model.SIZBPHLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZBPHLVBZ") == true && model.WZBPHLVBZ != null)
              {
                   strFieldSQL += ",WZBPHLVBZ";
                   strValueSQL += ",'" + model.WZBPHLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZBPHLVBZ") == true && model.LZBPHLVBZ != null)
              {
                   strFieldSQL += ",LZBPHLVBZ";
                   strValueSQL += ",'" + model.LZBPHLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZDLVBZ") == true && model.YZZDLVBZ != null)
              {
                   strFieldSQL += ",YZZDLVBZ";
                   strValueSQL += ",'" + model.YZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZDLVBZ") == true && model.EZZDLVBZ != null)
              {
                   strFieldSQL += ",EZZDLVBZ";
                   strValueSQL += ",'" + model.EZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZDLVBZ") == true && model.SZZDLVBZ != null)
              {
                   strFieldSQL += ",SZZDLVBZ";
                   strValueSQL += ",'" + model.SZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZDLVBZ") == true && model.SIZZDLVBZ != null)
              {
                   strFieldSQL += ",SIZZDLVBZ";
                   strValueSQL += ",'" + model.SIZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZDLVBZ") == true && model.WZZDLVBZ != null)
              {
                   strFieldSQL += ",WZZDLVBZ";
                   strValueSQL += ",'" + model.WZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZDLVBZ") == true && model.LZZDLVBZ != null)
              {
                   strFieldSQL += ",LZZDLVBZ";
                   strValueSQL += ",'" + model.LZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZDLVBZ") == true && model.SZDLVBZ != null)
              {
                   strFieldSQL += ",SZDLVBZ";
                   strValueSQL += ",'" + model.SZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCZDLVBZ") == true && model.ZCZDLVBZ != null)
              {
                   strFieldSQL += ",ZCZDLVBZ";
                   strValueSQL += ",'" + model.ZCZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("QCLCZCBZ") == true && model.QCLCZCBZ != null)
              {
                   strFieldSQL += ",QCLCZCBZ";
                   strValueSQL += ",'" + model.QCLCZCBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("QCLCZC_PD") == true && model.QCLCZC_PD != null)
              {
                   strFieldSQL += ",QCLCZC_PD";
                   strValueSQL += ",'" + model.QCLCZC_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("QCLCZCZDLV") == true && model.QCLCZCZDLV != null)
              {
                   strFieldSQL += ",QCLCZCZDLV";
                   strValueSQL += ",'" + model.QCLCZCZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZZCZDL") == true && model.ZZCZDL != null)
              {
                   strFieldSQL += ",ZZCZDL";
                   strValueSQL += ",'" + model.ZZCZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZCZDL") == true && model.YZCZDL != null)
              {
                   strFieldSQL += ",YZCZDL";
                   strValueSQL += ",'" + model.YZCZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("QZBPHLVBZ") == true && model.QZBPHLVBZ != null)
              {
                   strFieldSQL += ",QZBPHLVBZ";
                   strValueSQL += ",'" + model.QZBPHLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("HZBPHLVBZDY60") == true && model.HZBPHLVBZDY60 != null)
              {
                   strFieldSQL += ",HZBPHLVBZDY60";
                   strValueSQL += ",'" + model.HZBPHLVBZDY60.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("HZBPHLVBZXY60") == true && model.HZBPHLVBZXY60 != null)
              {
                   strFieldSQL += ",HZBPHLVBZXY60";
                   strValueSQL += ",'" + model.HZBPHLVBZXY60.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTYZZZ") == true && model.FHTYZZZ != null)
              {
                   strFieldSQL += ",FHTYZZZ";
                   strValueSQL += ",'" + model.FHTYZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTYZZLZ") == true && model.FHTYZZLZ != null)
              {
                   strFieldSQL += ",FHTYZZLZ";
                   strValueSQL += ",'" + model.FHTYZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTYZYLZ") == true && model.FHTYZYLZ != null)
              {
                   strFieldSQL += ",FHTYZYLZ";
                   strValueSQL += ",'" + model.FHTYZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTEZZZ") == true && model.FHTEZZZ != null)
              {
                   strFieldSQL += ",FHTEZZZ";
                   strValueSQL += ",'" + model.FHTEZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTEZZLZ") == true && model.FHTEZZLZ != null)
              {
                   strFieldSQL += ",FHTEZZLZ";
                   strValueSQL += ",'" + model.FHTEZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTEZYLZ") == true && model.FHTEZYLZ != null)
              {
                   strFieldSQL += ",FHTEZYLZ";
                   strValueSQL += ",'" + model.FHTEZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTSZZZ") == true && model.FHTSZZZ != null)
              {
                   strFieldSQL += ",FHTSZZZ";
                   strValueSQL += ",'" + model.FHTSZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTSZZLZ") == true && model.FHTSZZLZ != null)
              {
                   strFieldSQL += ",FHTSZZLZ";
                   strValueSQL += ",'" + model.FHTSZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTSZYLZ") == true && model.FHTSZYLZ != null)
              {
                   strFieldSQL += ",FHTSZYLZ";
                   strValueSQL += ",'" + model.FHTSZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTSIZZZ") == true && model.FHTSIZZZ != null)
              {
                   strFieldSQL += ",FHTSIZZZ";
                   strValueSQL += ",'" + model.FHTSIZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTSIZZLZ") == true && model.FHTSIZZLZ != null)
              {
                   strFieldSQL += ",FHTSIZZLZ";
                   strValueSQL += ",'" + model.FHTSIZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTSIZYLZ") == true && model.FHTSIZYLZ != null)
              {
                   strFieldSQL += ",FHTSIZYLZ";
                   strValueSQL += ",'" + model.FHTSIZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTWZZZ") == true && model.FHTWZZZ != null)
              {
                   strFieldSQL += ",FHTWZZZ";
                   strValueSQL += ",'" + model.FHTWZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTWZZLZ") == true && model.FHTWZZLZ != null)
              {
                   strFieldSQL += ",FHTWZZLZ";
                   strValueSQL += ",'" + model.FHTWZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTWZYLZ") == true && model.FHTWZYLZ != null)
              {
                   strFieldSQL += ",FHTWZYLZ";
                   strValueSQL += ",'" + model.FHTWZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTLZZZ") == true && model.FHTLZZZ != null)
              {
                   strFieldSQL += ",FHTLZZZ";
                   strValueSQL += ",'" + model.FHTLZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTLZZLZ") == true && model.FHTLZZLZ != null)
              {
                   strFieldSQL += ",FHTLZZLZ";
                   strValueSQL += ",'" + model.FHTLZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTLZYLZ") == true && model.FHTLZYLZ != null)
              {
                   strFieldSQL += ",FHTLZYLZ";
                   strValueSQL += ",'" + model.FHTLZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZJZZDLVBZ") == true && model.YZJZZDLVBZ != null)
              {
                   strFieldSQL += ",YZJZZDLVBZ";
                   strValueSQL += ",'" + model.YZJZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZJZZDLVBZ") == true && model.EZJZZDLVBZ != null)
              {
                   strFieldSQL += ",EZJZZDLVBZ";
                   strValueSQL += ",'" + model.EZJZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZJZZDLVBZ") == true && model.SZJZZDLVBZ != null)
              {
                   strFieldSQL += ",SZJZZDLVBZ";
                   strValueSQL += ",'" + model.SZJZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZJZZDLVBZ") == true && model.SIZJZZDLVBZ != null)
              {
                   strFieldSQL += ",SIZJZZDLVBZ";
                   strValueSQL += ",'" + model.SIZJZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZJZZDLVBZ") == true && model.WZJZZDLVBZ != null)
              {
                   strFieldSQL += ",WZJZZDLVBZ";
                   strValueSQL += ",'" + model.WZJZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZJZZDLVBZ") == true && model.LZJZZDLVBZ != null)
              {
                   strFieldSQL += ",LZJZZDLVBZ";
                   strValueSQL += ",'" + model.LZJZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              string strSql = "";
              strSql += "insert into RESULT_BRAKE";
              strSql += "(";
              strSql += strFieldSQL.Substring(1);
              strSql += ")";
              strSql += " values";
              strSql += "(";
              strSql += strValueSQL.Substring(1);
              strSql += ")";

              return strSql;
          }

          /// <summary>
          /// 添加一条数据
          /// </summary>
          public bool Insert(RESULT_BRAKE model)
          {
              return DbHelper.ExecuteSql(InsertSQL(model));
          }

          /// <summary>
          /// 修改一条数据 SQL
          /// </summary>
          public string UpdateSQL(RESULT_BRAKE model,string strJCLSH)
          {
              string strUpdateSQL = "";

              if(model.Changed("ID") == true && model.ID != null)
              {
                  strUpdateSQL += ",ID=" + model.ID + "";
              }

              if(model.Changed("ZDYZJCCS") == true && model.ZDYZJCCS != null)
              {
                  strUpdateSQL += ",ZDYZJCCS='" + model.ZDYZJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZDEZJCCS") == true && model.ZDEZJCCS != null)
              {
                  strUpdateSQL += ",ZDEZJCCS='" + model.ZDEZJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZDSZJCCS") == true && model.ZDSZJCCS != null)
              {
                  strUpdateSQL += ",ZDSZJCCS='" + model.ZDSZJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZDSIZJCCS") == true && model.ZDSIZJCCS != null)
              {
                  strUpdateSQL += ",ZDSIZJCCS='" + model.ZDSIZJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZDWZJCCS") == true && model.ZDWZJCCS != null)
              {
                  strUpdateSQL += ",ZDWZJCCS='" + model.ZDWZJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZDLZJCCS") == true && model.ZDLZJCCS != null)
              {
                  strUpdateSQL += ",ZDLZJCCS='" + model.ZDLZJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZDSZDJCCS") == true && model.ZDSZDJCCS != null)
              {
                  strUpdateSQL += ",ZDSZDJCCS='" + model.ZDSZDJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZDZCJCCS") == true && model.ZDZCJCCS != null)
              {
                  strUpdateSQL += ",ZDZCJCCS='" + model.ZDZCJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JCLSH") == true && model.JCLSH != null)
              {
                  strUpdateSQL += ",JCLSH='" + model.JCLSH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZLZ") == true && model.YZZLZ != null)
              {
                  strUpdateSQL += ",YZZLZ='" + model.YZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYLZ") == true && model.YZYLZ != null)
              {
                  strUpdateSQL += ",YZYLZ='" + model.YZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZ") == true && model.YZZZ != null)
              {
                  strUpdateSQL += ",YZZZ='" + model.YZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZLZ") == true && model.EZZLZ != null)
              {
                  strUpdateSQL += ",EZZLZ='" + model.EZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYLZ") == true && model.EZYLZ != null)
              {
                  strUpdateSQL += ",EZYLZ='" + model.EZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZ") == true && model.EZZZ != null)
              {
                  strUpdateSQL += ",EZZZ='" + model.EZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZLZ") == true && model.SZZLZ != null)
              {
                  strUpdateSQL += ",SZZLZ='" + model.SZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZYLZ") == true && model.SZYLZ != null)
              {
                  strUpdateSQL += ",SZYLZ='" + model.SZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZ") == true && model.SZZZ != null)
              {
                  strUpdateSQL += ",SZZZ='" + model.SZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZLZ") == true && model.SIZZLZ != null)
              {
                  strUpdateSQL += ",SIZZLZ='" + model.SIZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZYLZ") == true && model.SIZYLZ != null)
              {
                  strUpdateSQL += ",SIZYLZ='" + model.SIZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZ") == true && model.SIZZZ != null)
              {
                  strUpdateSQL += ",SIZZZ='" + model.SIZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZLZ") == true && model.WZZLZ != null)
              {
                  strUpdateSQL += ",WZZLZ='" + model.WZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZYLZ") == true && model.WZYLZ != null)
              {
                  strUpdateSQL += ",WZYLZ='" + model.WZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZ") == true && model.WZZZ != null)
              {
                  strUpdateSQL += ",WZZZ='" + model.WZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZLZ") == true && model.LZZLZ != null)
              {
                  strUpdateSQL += ",LZZLZ='" + model.LZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZYLZ") == true && model.LZYLZ != null)
              {
                  strUpdateSQL += ",LZYLZ='" + model.LZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZ") == true && model.LZZZ != null)
              {
                  strUpdateSQL += ",LZZZ='" + model.LZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZDTLH") == true && model.YZZDTLH != null)
              {
                  strUpdateSQL += ",YZZDTLH='" + model.YZZDTLH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYDTLH") == true && model.YZYDTLH != null)
              {
                  strUpdateSQL += ",YZYDTLH='" + model.YZYDTLH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZDTLH") == true && model.YZDTLH != null)
              {
                  strUpdateSQL += ",YZDTLH='" + model.YZDTLH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZDTLH") == true && model.EZZDTLH != null)
              {
                  strUpdateSQL += ",EZZDTLH='" + model.EZZDTLH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYDTLH") == true && model.EZYDTLH != null)
              {
                  strUpdateSQL += ",EZYDTLH='" + model.EZYDTLH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZDTLH") == true && model.EZDTLH != null)
              {
                  strUpdateSQL += ",EZDTLH='" + model.EZDTLH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCZLZ") == true && model.ZCZLZ != null)
              {
                  strUpdateSQL += ",ZCZLZ='" + model.ZCZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCYLZ") == true && model.ZCYLZ != null)
              {
                  strUpdateSQL += ",ZCYLZ='" + model.ZCYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCZZ") == true && model.ZCZZ != null)
              {
                  strUpdateSQL += ",ZCZZ='" + model.ZCZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZZL") == true && model.YZZZZL != null)
              {
                  strUpdateSQL += ",YZZZZL='" + model.YZZZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYZZL") == true && model.YZYZZL != null)
              {
                  strUpdateSQL += ",YZYZZL='" + model.YZYZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZZLV") == true && model.YZZZZLV != null)
              {
                  strUpdateSQL += ",YZZZZLV='" + model.YZZZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYZZLV") == true && model.YZYZZLV != null)
              {
                  strUpdateSQL += ",YZYZZLV='" + model.YZYZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZZL_PD") == true && model.YZZZZL_PD != null)
              {
                  strUpdateSQL += ",YZZZZL_PD='" + model.YZZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYZZL_PD") == true && model.YZYZZL_PD != null)
              {
                  strUpdateSQL += ",YZYZZL_PD='" + model.YZYZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZL_PD") == true && model.YZZZL_PD != null)
              {
                  strUpdateSQL += ",YZZZL_PD='" + model.YZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZZL") == true && model.EZZZZL != null)
              {
                  strUpdateSQL += ",EZZZZL='" + model.EZZZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYZZL") == true && model.EZYZZL != null)
              {
                  strUpdateSQL += ",EZYZZL='" + model.EZYZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZZLV") == true && model.EZZZZLV != null)
              {
                  strUpdateSQL += ",EZZZZLV='" + model.EZZZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYZZLV") == true && model.EZYZZLV != null)
              {
                  strUpdateSQL += ",EZYZZLV='" + model.EZYZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZZL_PD") == true && model.EZZZZL_PD != null)
              {
                  strUpdateSQL += ",EZZZZL_PD='" + model.EZZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYZZL_PD") == true && model.EZYZZL_PD != null)
              {
                  strUpdateSQL += ",EZYZZL_PD='" + model.EZYZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZL_PD") == true && model.EZZZL_PD != null)
              {
                  strUpdateSQL += ",EZZZL_PD='" + model.EZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZZL") == true && model.SZZZZL != null)
              {
                  strUpdateSQL += ",SZZZZL='" + model.SZZZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZYZZL") == true && model.SZYZZL != null)
              {
                  strUpdateSQL += ",SZYZZL='" + model.SZYZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZZLV") == true && model.SZZZZLV != null)
              {
                  strUpdateSQL += ",SZZZZLV='" + model.SZZZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZYZZLV") == true && model.SZYZZLV != null)
              {
                  strUpdateSQL += ",SZYZZLV='" + model.SZYZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZZL_PD") == true && model.SZZZZL_PD != null)
              {
                  strUpdateSQL += ",SZZZZL_PD='" + model.SZZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZYZZL_PD") == true && model.SZYZZL_PD != null)
              {
                  strUpdateSQL += ",SZYZZL_PD='" + model.SZYZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZL_PD") == true && model.SZZZL_PD != null)
              {
                  strUpdateSQL += ",SZZZL_PD='" + model.SZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZZL") == true && model.SIZZZZL != null)
              {
                  strUpdateSQL += ",SIZZZZL='" + model.SIZZZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZYZZL") == true && model.SIZYZZL != null)
              {
                  strUpdateSQL += ",SIZYZZL='" + model.SIZYZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZZLV") == true && model.SIZZZZLV != null)
              {
                  strUpdateSQL += ",SIZZZZLV='" + model.SIZZZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZYZZLV") == true && model.SIZYZZLV != null)
              {
                  strUpdateSQL += ",SIZYZZLV='" + model.SIZYZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZZL_PD") == true && model.SIZZZZL_PD != null)
              {
                  strUpdateSQL += ",SIZZZZL_PD='" + model.SIZZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZYZZL_PD") == true && model.SIZYZZL_PD != null)
              {
                  strUpdateSQL += ",SIZYZZL_PD='" + model.SIZYZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZL_PD") == true && model.SIZZZL_PD != null)
              {
                  strUpdateSQL += ",SIZZZL_PD='" + model.SIZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZZL") == true && model.WZZZZL != null)
              {
                  strUpdateSQL += ",WZZZZL='" + model.WZZZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZYZZL") == true && model.WZYZZL != null)
              {
                  strUpdateSQL += ",WZYZZL='" + model.WZYZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZZLV") == true && model.WZZZZLV != null)
              {
                  strUpdateSQL += ",WZZZZLV='" + model.WZZZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZYZZLV") == true && model.WZYZZLV != null)
              {
                  strUpdateSQL += ",WZYZZLV='" + model.WZYZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZZL_PD") == true && model.WZZZZL_PD != null)
              {
                  strUpdateSQL += ",WZZZZL_PD='" + model.WZZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZYZZL_PD") == true && model.WZYZZL_PD != null)
              {
                  strUpdateSQL += ",WZYZZL_PD='" + model.WZYZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZL_PD") == true && model.WZZZL_PD != null)
              {
                  strUpdateSQL += ",WZZZL_PD='" + model.WZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZZL") == true && model.LZZZZL != null)
              {
                  strUpdateSQL += ",LZZZZL='" + model.LZZZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZYZZL") == true && model.LZYZZL != null)
              {
                  strUpdateSQL += ",LZYZZL='" + model.LZYZZL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZZLV") == true && model.LZZZZLV != null)
              {
                  strUpdateSQL += ",LZZZZLV='" + model.LZZZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZYZZLV") == true && model.LZYZZLV != null)
              {
                  strUpdateSQL += ",LZYZZLV='" + model.LZYZZLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZZL_PD") == true && model.LZZZZL_PD != null)
              {
                  strUpdateSQL += ",LZZZZL_PD='" + model.LZZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZYZZL_PD") == true && model.LZYZZL_PD != null)
              {
                  strUpdateSQL += ",LZYZZL_PD='" + model.LZYZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZL_PD") == true && model.LZZZL_PD != null)
              {
                  strUpdateSQL += ",LZZZL_PD='" + model.LZZZL_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZDCZD") == true && model.YZZZDCZD != null)
              {
                  strUpdateSQL += ",YZZZDCZD='" + model.YZZZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYZDCZD") == true && model.YZYZDCZD != null)
              {
                  strUpdateSQL += ",YZYZDCZD='" + model.YZYZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZBPHLV") == true && model.YZBPHLV != null)
              {
                  strUpdateSQL += ",YZBPHLV='" + model.YZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZBPHLV_PD") == true && model.YZBPHLV_PD != null)
              {
                  strUpdateSQL += ",YZBPHLV_PD='" + model.YZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZDCZD") == true && model.EZZZDCZD != null)
              {
                  strUpdateSQL += ",EZZZDCZD='" + model.EZZZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYZDCZD") == true && model.EZYZDCZD != null)
              {
                  strUpdateSQL += ",EZYZDCZD='" + model.EZYZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZBPHLV") == true && model.EZBPHLV != null)
              {
                  strUpdateSQL += ",EZBPHLV='" + model.EZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZBPHLV_PD") == true && model.EZBPHLV_PD != null)
              {
                  strUpdateSQL += ",EZBPHLV_PD='" + model.EZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZDCZD") == true && model.SZZZDCZD != null)
              {
                  strUpdateSQL += ",SZZZDCZD='" + model.SZZZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZYZDCZD") == true && model.SZYZDCZD != null)
              {
                  strUpdateSQL += ",SZYZDCZD='" + model.SZYZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZBPHLV") == true && model.SZBPHLV != null)
              {
                  strUpdateSQL += ",SZBPHLV='" + model.SZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZBPHLV_PD") == true && model.SZBPHLV_PD != null)
              {
                  strUpdateSQL += ",SZBPHLV_PD='" + model.SZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZDCZD") == true && model.SIZZZDCZD != null)
              {
                  strUpdateSQL += ",SIZZZDCZD='" + model.SIZZZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZYZDCZD") == true && model.SIZYZDCZD != null)
              {
                  strUpdateSQL += ",SIZYZDCZD='" + model.SIZYZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZBPHLV") == true && model.SIZBPHLV != null)
              {
                  strUpdateSQL += ",SIZBPHLV='" + model.SIZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZBPHLV_PD") == true && model.SIZBPHLV_PD != null)
              {
                  strUpdateSQL += ",SIZBPHLV_PD='" + model.SIZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZDCZD") == true && model.WZZZDCZD != null)
              {
                  strUpdateSQL += ",WZZZDCZD='" + model.WZZZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZYZDCZD") == true && model.WZYZDCZD != null)
              {
                  strUpdateSQL += ",WZYZDCZD='" + model.WZYZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZBPHLV") == true && model.WZBPHLV != null)
              {
                  strUpdateSQL += ",WZBPHLV='" + model.WZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZBPHLV_PD") == true && model.WZBPHLV_PD != null)
              {
                  strUpdateSQL += ",WZBPHLV_PD='" + model.WZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZDCZD") == true && model.LZZZDCZD != null)
              {
                  strUpdateSQL += ",LZZZDCZD='" + model.LZZZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZYZDCZD") == true && model.LZYZDCZD != null)
              {
                  strUpdateSQL += ",LZYZDCZD='" + model.LZYZDCZD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZBPHLV") == true && model.LZBPHLV != null)
              {
                  strUpdateSQL += ",LZBPHLV='" + model.LZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZBPHLV_PD") == true && model.LZBPHLV_PD != null)
              {
                  strUpdateSQL += ",LZBPHLV_PD='" + model.LZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZDZDL") == true && model.YZZZDZDL != null)
              {
                  strUpdateSQL += ",YZZZDZDL='" + model.YZZZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYZDZDL") == true && model.YZYZDZDL != null)
              {
                  strUpdateSQL += ",YZYZDZDL='" + model.YZYZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZDLV") == true && model.YZZDLV != null)
              {
                  strUpdateSQL += ",YZZDLV='" + model.YZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZDLV_PD") == true && model.YZZDLV_PD != null)
              {
                  strUpdateSQL += ",YZZDLV_PD='" + model.YZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZDZDL") == true && model.EZZZDZDL != null)
              {
                  strUpdateSQL += ",EZZZDZDL='" + model.EZZZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYZDZDL") == true && model.EZYZDZDL != null)
              {
                  strUpdateSQL += ",EZYZDZDL='" + model.EZYZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZDLV") == true && model.EZZDLV != null)
              {
                  strUpdateSQL += ",EZZDLV='" + model.EZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZDLV_PD") == true && model.EZZDLV_PD != null)
              {
                  strUpdateSQL += ",EZZDLV_PD='" + model.EZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZDZDL") == true && model.SZZZDZDL != null)
              {
                  strUpdateSQL += ",SZZZDZDL='" + model.SZZZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZYZDZDL") == true && model.SZYZDZDL != null)
              {
                  strUpdateSQL += ",SZYZDZDL='" + model.SZYZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZDLV") == true && model.SZZDLV != null)
              {
                  strUpdateSQL += ",SZZDLV='" + model.SZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZDLV_PD") == true && model.SZZDLV_PD != null)
              {
                  strUpdateSQL += ",SZZDLV_PD='" + model.SZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZDZDL") == true && model.SIZZZDZDL != null)
              {
                  strUpdateSQL += ",SIZZZDZDL='" + model.SIZZZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZYZDZDL") == true && model.SIZYZDZDL != null)
              {
                  strUpdateSQL += ",SIZYZDZDL='" + model.SIZYZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZDLV") == true && model.SIZZDLV != null)
              {
                  strUpdateSQL += ",SIZZDLV='" + model.SIZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZDLV_PD") == true && model.SIZZDLV_PD != null)
              {
                  strUpdateSQL += ",SIZZDLV_PD='" + model.SIZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZDZDL") == true && model.WZZZDZDL != null)
              {
                  strUpdateSQL += ",WZZZDZDL='" + model.WZZZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZYZDZDL") == true && model.WZYZDZDL != null)
              {
                  strUpdateSQL += ",WZYZDZDL='" + model.WZYZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZDLV") == true && model.WZZDLV != null)
              {
                  strUpdateSQL += ",WZZDLV='" + model.WZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZDLV_PD") == true && model.WZZDLV_PD != null)
              {
                  strUpdateSQL += ",WZZDLV_PD='" + model.WZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZDZDL") == true && model.LZZZDZDL != null)
              {
                  strUpdateSQL += ",LZZZDZDL='" + model.LZZZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZYZDZDL") == true && model.LZYZDZDL != null)
              {
                  strUpdateSQL += ",LZYZDZDL='" + model.LZYZDZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZDLV") == true && model.LZZDLV != null)
              {
                  strUpdateSQL += ",LZZDLV='" + model.LZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZDLV_PD") == true && model.LZZDLV_PD != null)
              {
                  strUpdateSQL += ",LZZDLV_PD='" + model.LZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZSZDL") == true && model.YZZSZDL != null)
              {
                  strUpdateSQL += ",YZZSZDL='" + model.YZZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZYSZDL") == true && model.YZYSZDL != null)
              {
                  strUpdateSQL += ",YZYSZDL='" + model.YZYSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZSZDL") == true && model.YZSZDL != null)
              {
                  strUpdateSQL += ",YZSZDL='" + model.YZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZSZDL") == true && model.EZZSZDL != null)
              {
                  strUpdateSQL += ",EZZSZDL='" + model.EZZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZYSZDL") == true && model.EZYSZDL != null)
              {
                  strUpdateSQL += ",EZYSZDL='" + model.EZYSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZSZDL") == true && model.EZSZDL != null)
              {
                  strUpdateSQL += ",EZSZDL='" + model.EZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZSZDL") == true && model.SZZSZDL != null)
              {
                  strUpdateSQL += ",SZZSZDL='" + model.SZZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZYSZDL") == true && model.SZYSZDL != null)
              {
                  strUpdateSQL += ",SZYSZDL='" + model.SZYSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZSZDL") == true && model.SZSZDL != null)
              {
                  strUpdateSQL += ",SZSZDL='" + model.SZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZSZDL") == true && model.SIZZSZDL != null)
              {
                  strUpdateSQL += ",SIZZSZDL='" + model.SIZZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZYSZDL") == true && model.SIZYSZDL != null)
              {
                  strUpdateSQL += ",SIZYSZDL='" + model.SIZYSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZSZDL") == true && model.SIZSZDL != null)
              {
                  strUpdateSQL += ",SIZSZDL='" + model.SIZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZSZDL") == true && model.WZZSZDL != null)
              {
                  strUpdateSQL += ",WZZSZDL='" + model.WZZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZYSZDL") == true && model.WZYSZDL != null)
              {
                  strUpdateSQL += ",WZYSZDL='" + model.WZYSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZSZDL") == true && model.WZSZDL != null)
              {
                  strUpdateSQL += ",WZSZDL='" + model.WZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZSZDL") == true && model.LZZSZDL != null)
              {
                  strUpdateSQL += ",LZZSZDL='" + model.LZZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZYSZDL") == true && model.LZYSZDL != null)
              {
                  strUpdateSQL += ",LZYSZDL='" + model.LZYSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZSZDL") == true && model.LZSZDL != null)
              {
                  strUpdateSQL += ",LZSZDL='" + model.LZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZZSZDL") == true && model.ZZSZDL != null)
              {
                  strUpdateSQL += ",ZZSZDL='" + model.ZZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZYSZDL") == true && model.ZYSZDL != null)
              {
                  strUpdateSQL += ",ZYSZDL='" + model.ZYSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZSZDL") == true && model.ZSZDL != null)
              {
                  strUpdateSQL += ",ZSZDL='" + model.ZSZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCSZDLV") == true && model.ZCSZDLV != null)
              {
                  strUpdateSQL += ",ZCSZDLV='" + model.ZCSZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZDLV_PD") == true && model.SZDLV_PD != null)
              {
                  strUpdateSQL += ",SZDLV_PD='" + model.SZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCZDL") == true && model.ZCZDL != null)
              {
                  strUpdateSQL += ",ZCZDL='" + model.ZCZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCZDLV") == true && model.ZCZDLV != null)
              {
                  strUpdateSQL += ",ZCZDLV='" + model.ZCZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCZDLV_PD") == true && model.ZCZDLV_PD != null)
              {
                  strUpdateSQL += ",ZCZDLV_PD='" + model.ZCZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZJZZZ") == true && model.YZJZZZ != null)
              {
                  strUpdateSQL += ",YZJZZZ='" + model.YZJZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZJZZZ") == true && model.EZJZZZ != null)
              {
                  strUpdateSQL += ",EZJZZZ='" + model.EZJZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZJZZZ") == true && model.SZJZZZ != null)
              {
                  strUpdateSQL += ",SZJZZZ='" + model.SZJZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZJZZZ") == true && model.SIZJZZZ != null)
              {
                  strUpdateSQL += ",SIZJZZZ='" + model.SIZJZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZJZZZ") == true && model.WZJZZZ != null)
              {
                  strUpdateSQL += ",WZJZZZ='" + model.WZJZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZJZZZ") == true && model.LZJZZZ != null)
              {
                  strUpdateSQL += ",LZJZZZ='" + model.LZJZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZJZZDLV") == true && model.YZJZZDLV != null)
              {
                  strUpdateSQL += ",YZJZZDLV='" + model.YZJZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZJZZDLV_PD") == true && model.YZJZZDLV_PD != null)
              {
                  strUpdateSQL += ",YZJZZDLV_PD='" + model.YZJZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZJZZDLV") == true && model.EZJZZDLV != null)
              {
                  strUpdateSQL += ",EZJZZDLV='" + model.EZJZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZJZZDLV_PD") == true && model.EZJZZDLV_PD != null)
              {
                  strUpdateSQL += ",EZJZZDLV_PD='" + model.EZJZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZJZZDLV") == true && model.SZJZZDLV != null)
              {
                  strUpdateSQL += ",SZJZZDLV='" + model.SZJZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZJZZDLV_PD") == true && model.SZJZZDLV_PD != null)
              {
                  strUpdateSQL += ",SZJZZDLV_PD='" + model.SZJZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZJZZDLV") == true && model.SIZJZZDLV != null)
              {
                  strUpdateSQL += ",SIZJZZDLV='" + model.SIZJZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZJZZDLV_PD") == true && model.SIZJZZDLV_PD != null)
              {
                  strUpdateSQL += ",SIZJZZDLV_PD='" + model.SIZJZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZJZZDLV") == true && model.WZJZZDLV != null)
              {
                  strUpdateSQL += ",WZJZZDLV='" + model.WZJZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZJZZDLV_PD") == true && model.WZJZZDLV_PD != null)
              {
                  strUpdateSQL += ",WZJZZDLV_PD='" + model.WZJZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZJZZDLV") == true && model.LZJZZDLV != null)
              {
                  strUpdateSQL += ",LZJZZDLV='" + model.LZJZZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZJZZDLV_PD") == true && model.LZJZZDLV_PD != null)
              {
                  strUpdateSQL += ",LZJZZDLV_PD='" + model.LZJZZDLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZJZBPHLV") == true && model.YZJZBPHLV != null)
              {
                  strUpdateSQL += ",YZJZBPHLV='" + model.YZJZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZJZBPHLV_PD") == true && model.YZJZBPHLV_PD != null)
              {
                  strUpdateSQL += ",YZJZBPHLV_PD='" + model.YZJZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZJZBPHLV") == true && model.EZJZBPHLV != null)
              {
                  strUpdateSQL += ",EZJZBPHLV='" + model.EZJZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZJZBPHLV_PD") == true && model.EZJZBPHLV_PD != null)
              {
                  strUpdateSQL += ",EZJZBPHLV_PD='" + model.EZJZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZJZBPHLV") == true && model.SZJZBPHLV != null)
              {
                  strUpdateSQL += ",SZJZBPHLV='" + model.SZJZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZJZBPHLV_PD") == true && model.SZJZBPHLV_PD != null)
              {
                  strUpdateSQL += ",SZJZBPHLV_PD='" + model.SZJZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZJZBPHLV") == true && model.SIZJZBPHLV != null)
              {
                  strUpdateSQL += ",SIZJZBPHLV='" + model.SIZJZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZJZBPHLV_PD") == true && model.SIZJZBPHLV_PD != null)
              {
                  strUpdateSQL += ",SIZJZBPHLV_PD='" + model.SIZJZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZJZBPHLV") == true && model.WZJZBPHLV != null)
              {
                  strUpdateSQL += ",WZJZBPHLV='" + model.WZJZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZJZBPHLV_PD") == true && model.WZJZBPHLV_PD != null)
              {
                  strUpdateSQL += ",WZJZBPHLV_PD='" + model.WZJZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZJZBPHLV") == true && model.LZJZBPHLV != null)
              {
                  strUpdateSQL += ",LZJZBPHLV='" + model.LZJZBPHLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZJZBPHLV_PD") == true && model.LZJZBPHLV_PD != null)
              {
                  strUpdateSQL += ",LZJZBPHLV_PD='" + model.LZJZBPHLV_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZDZ_PD") == true && model.YZZDZ_PD != null)
              {
                  strUpdateSQL += ",YZZDZ_PD='" + model.YZZDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZDZ_PD") == true && model.EZZDZ_PD != null)
              {
                  strUpdateSQL += ",EZZDZ_PD='" + model.EZZDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZDZ_PD") == true && model.SZZDZ_PD != null)
              {
                  strUpdateSQL += ",SZZDZ_PD='" + model.SZZDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZDZ_PD") == true && model.SIZZDZ_PD != null)
              {
                  strUpdateSQL += ",SIZZDZ_PD='" + model.SIZZDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZDZ_PD") == true && model.WZZDZ_PD != null)
              {
                  strUpdateSQL += ",WZZDZ_PD='" + model.WZZDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZDZ_PD") == true && model.LZZDZ_PD != null)
              {
                  strUpdateSQL += ",LZZDZ_PD='" + model.LZZDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZZLVXZBZ") == true && model.YZZZLVXZBZ != null)
              {
                  strUpdateSQL += ",YZZZLVXZBZ='" + model.YZZZLVXZBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZZLVXZBZ") == true && model.EZZZLVXZBZ != null)
              {
                  strUpdateSQL += ",EZZZLVXZBZ='" + model.EZZZLVXZBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZZLVXZBZ") == true && model.SZZZLVXZBZ != null)
              {
                  strUpdateSQL += ",SZZZLVXZBZ='" + model.SZZZLVXZBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZZLVXZBZ") == true && model.SIZZZLVXZBZ != null)
              {
                  strUpdateSQL += ",SIZZZLVXZBZ='" + model.SIZZZLVXZBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZZLVXZBZ") == true && model.WZZZLVXZBZ != null)
              {
                  strUpdateSQL += ",WZZZLVXZBZ='" + model.WZZZLVXZBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZZLVXZBZ") == true && model.LZZZLVXZBZ != null)
              {
                  strUpdateSQL += ",LZZZLVXZBZ='" + model.LZZZLVXZBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZBPHLVBZ") == true && model.YZBPHLVBZ != null)
              {
                  strUpdateSQL += ",YZBPHLVBZ='" + model.YZBPHLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZBPHLVBZ") == true && model.EZBPHLVBZ != null)
              {
                  strUpdateSQL += ",EZBPHLVBZ='" + model.EZBPHLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZBPHLVBZ") == true && model.SZBPHLVBZ != null)
              {
                  strUpdateSQL += ",SZBPHLVBZ='" + model.SZBPHLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZBPHLVBZ") == true && model.SIZBPHLVBZ != null)
              {
                  strUpdateSQL += ",SIZBPHLVBZ='" + model.SIZBPHLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZBPHLVBZ") == true && model.WZBPHLVBZ != null)
              {
                  strUpdateSQL += ",WZBPHLVBZ='" + model.WZBPHLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZBPHLVBZ") == true && model.LZBPHLVBZ != null)
              {
                  strUpdateSQL += ",LZBPHLVBZ='" + model.LZBPHLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZZDLVBZ") == true && model.YZZDLVBZ != null)
              {
                  strUpdateSQL += ",YZZDLVBZ='" + model.YZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZZDLVBZ") == true && model.EZZDLVBZ != null)
              {
                  strUpdateSQL += ",EZZDLVBZ='" + model.EZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZZDLVBZ") == true && model.SZZDLVBZ != null)
              {
                  strUpdateSQL += ",SZZDLVBZ='" + model.SZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZZDLVBZ") == true && model.SIZZDLVBZ != null)
              {
                  strUpdateSQL += ",SIZZDLVBZ='" + model.SIZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZZDLVBZ") == true && model.WZZDLVBZ != null)
              {
                  strUpdateSQL += ",WZZDLVBZ='" + model.WZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZZDLVBZ") == true && model.LZZDLVBZ != null)
              {
                  strUpdateSQL += ",LZZDLVBZ='" + model.LZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZDLVBZ") == true && model.SZDLVBZ != null)
              {
                  strUpdateSQL += ",SZDLVBZ='" + model.SZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZCZDLVBZ") == true && model.ZCZDLVBZ != null)
              {
                  strUpdateSQL += ",ZCZDLVBZ='" + model.ZCZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("QCLCZCBZ") == true && model.QCLCZCBZ != null)
              {
                  strUpdateSQL += ",QCLCZCBZ='" + model.QCLCZCBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("QCLCZC_PD") == true && model.QCLCZC_PD != null)
              {
                  strUpdateSQL += ",QCLCZC_PD='" + model.QCLCZC_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("QCLCZCZDLV") == true && model.QCLCZCZDLV != null)
              {
                  strUpdateSQL += ",QCLCZCZDLV='" + model.QCLCZCZDLV.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZZCZDL") == true && model.ZZCZDL != null)
              {
                  strUpdateSQL += ",ZZCZDL='" + model.ZZCZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZCZDL") == true && model.YZCZDL != null)
              {
                  strUpdateSQL += ",YZCZDL='" + model.YZCZDL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("QZBPHLVBZ") == true && model.QZBPHLVBZ != null)
              {
                  strUpdateSQL += ",QZBPHLVBZ='" + model.QZBPHLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("HZBPHLVBZDY60") == true && model.HZBPHLVBZDY60 != null)
              {
                  strUpdateSQL += ",HZBPHLVBZDY60='" + model.HZBPHLVBZDY60.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("HZBPHLVBZXY60") == true && model.HZBPHLVBZXY60 != null)
              {
                  strUpdateSQL += ",HZBPHLVBZXY60='" + model.HZBPHLVBZXY60.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTYZZZ") == true && model.FHTYZZZ != null)
              {
                  strUpdateSQL += ",FHTYZZZ='" + model.FHTYZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTYZZLZ") == true && model.FHTYZZLZ != null)
              {
                  strUpdateSQL += ",FHTYZZLZ='" + model.FHTYZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTYZYLZ") == true && model.FHTYZYLZ != null)
              {
                  strUpdateSQL += ",FHTYZYLZ='" + model.FHTYZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTEZZZ") == true && model.FHTEZZZ != null)
              {
                  strUpdateSQL += ",FHTEZZZ='" + model.FHTEZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTEZZLZ") == true && model.FHTEZZLZ != null)
              {
                  strUpdateSQL += ",FHTEZZLZ='" + model.FHTEZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTEZYLZ") == true && model.FHTEZYLZ != null)
              {
                  strUpdateSQL += ",FHTEZYLZ='" + model.FHTEZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTSZZZ") == true && model.FHTSZZZ != null)
              {
                  strUpdateSQL += ",FHTSZZZ='" + model.FHTSZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTSZZLZ") == true && model.FHTSZZLZ != null)
              {
                  strUpdateSQL += ",FHTSZZLZ='" + model.FHTSZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTSZYLZ") == true && model.FHTSZYLZ != null)
              {
                  strUpdateSQL += ",FHTSZYLZ='" + model.FHTSZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTSIZZZ") == true && model.FHTSIZZZ != null)
              {
                  strUpdateSQL += ",FHTSIZZZ='" + model.FHTSIZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTSIZZLZ") == true && model.FHTSIZZLZ != null)
              {
                  strUpdateSQL += ",FHTSIZZLZ='" + model.FHTSIZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTSIZYLZ") == true && model.FHTSIZYLZ != null)
              {
                  strUpdateSQL += ",FHTSIZYLZ='" + model.FHTSIZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTWZZZ") == true && model.FHTWZZZ != null)
              {
                  strUpdateSQL += ",FHTWZZZ='" + model.FHTWZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTWZZLZ") == true && model.FHTWZZLZ != null)
              {
                  strUpdateSQL += ",FHTWZZLZ='" + model.FHTWZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTWZYLZ") == true && model.FHTWZYLZ != null)
              {
                  strUpdateSQL += ",FHTWZYLZ='" + model.FHTWZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTLZZZ") == true && model.FHTLZZZ != null)
              {
                  strUpdateSQL += ",FHTLZZZ='" + model.FHTLZZZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTLZZLZ") == true && model.FHTLZZLZ != null)
              {
                  strUpdateSQL += ",FHTLZZLZ='" + model.FHTLZZLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("FHTLZYLZ") == true && model.FHTLZYLZ != null)
              {
                  strUpdateSQL += ",FHTLZYLZ='" + model.FHTLZYLZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YZJZZDLVBZ") == true && model.YZJZZDLVBZ != null)
              {
                  strUpdateSQL += ",YZJZZDLVBZ='" + model.YZJZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("EZJZZDLVBZ") == true && model.EZJZZDLVBZ != null)
              {
                  strUpdateSQL += ",EZJZZDLVBZ='" + model.EZJZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SZJZZDLVBZ") == true && model.SZJZZDLVBZ != null)
              {
                  strUpdateSQL += ",SZJZZDLVBZ='" + model.SZJZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("SIZJZZDLVBZ") == true && model.SIZJZZDLVBZ != null)
              {
                  strUpdateSQL += ",SIZJZZDLVBZ='" + model.SIZJZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("WZJZZDLVBZ") == true && model.WZJZZDLVBZ != null)
              {
                  strUpdateSQL += ",WZJZZDLVBZ='" + model.WZJZZDLVBZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("LZJZZDLVBZ") == true && model.LZJZZDLVBZ != null)
              {
                  strUpdateSQL += ",LZJZZDLVBZ='" + model.LZJZZDLVBZ.ToString().Replace("'","''") + "'";
              }

               string strSql = "";
               strSql += "update RESULT_BRAKE set ";
               strSql += strUpdateSQL.Substring(1);
               strSql += " where ";
               strSql += " JCLSH='"+ strJCLSH +"'";

               return strSql;
          }

          /// <summary>
          /// 修改一条数据
          /// </summary>
          public bool Update(RESULT_BRAKE model, string strJCLSH)
          {
              return DbHelper.ExecuteSql(UpdateSQL(model, strJCLSH));
          }

          /// <summary>
          /// 修改一个集合 SQL
          /// </summary>
           public string UpdateRangeSQL(RESULT_BRAKE model, string p_strWhere)
          {
               string strUpdateSQL = "";

               if(model.Changed("ID") == true && model.ID != null)
               {
                  strUpdateSQL += ",ID=" + model.ID + "";
               }

               if(model.Changed("ZDYZJCCS") == true && model.ZDYZJCCS != null)
               {
                  strUpdateSQL += ",ZDYZJCCS='" + model.ZDYZJCCS.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZDEZJCCS") == true && model.ZDEZJCCS != null)
               {
                  strUpdateSQL += ",ZDEZJCCS='" + model.ZDEZJCCS.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZDSZJCCS") == true && model.ZDSZJCCS != null)
               {
                  strUpdateSQL += ",ZDSZJCCS='" + model.ZDSZJCCS.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZDSIZJCCS") == true && model.ZDSIZJCCS != null)
               {
                  strUpdateSQL += ",ZDSIZJCCS='" + model.ZDSIZJCCS.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZDWZJCCS") == true && model.ZDWZJCCS != null)
               {
                  strUpdateSQL += ",ZDWZJCCS='" + model.ZDWZJCCS.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZDLZJCCS") == true && model.ZDLZJCCS != null)
               {
                  strUpdateSQL += ",ZDLZJCCS='" + model.ZDLZJCCS.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZDSZDJCCS") == true && model.ZDSZDJCCS != null)
               {
                  strUpdateSQL += ",ZDSZDJCCS='" + model.ZDSZDJCCS.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZDZCJCCS") == true && model.ZDZCJCCS != null)
               {
                  strUpdateSQL += ",ZDZCJCCS='" + model.ZDZCJCCS.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("JCLSH") == true && model.JCLSH != null)
               {
                  strUpdateSQL += ",JCLSH='" + model.JCLSH.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZLZ") == true && model.YZZLZ != null)
               {
                  strUpdateSQL += ",YZZLZ='" + model.YZZLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZYLZ") == true && model.YZYLZ != null)
               {
                  strUpdateSQL += ",YZYLZ='" + model.YZYLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZZ") == true && model.YZZZ != null)
               {
                  strUpdateSQL += ",YZZZ='" + model.YZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZLZ") == true && model.EZZLZ != null)
               {
                  strUpdateSQL += ",EZZLZ='" + model.EZZLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZYLZ") == true && model.EZYLZ != null)
               {
                  strUpdateSQL += ",EZYLZ='" + model.EZYLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZZ") == true && model.EZZZ != null)
               {
                  strUpdateSQL += ",EZZZ='" + model.EZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZZLZ") == true && model.SZZLZ != null)
               {
                  strUpdateSQL += ",SZZLZ='" + model.SZZLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZYLZ") == true && model.SZYLZ != null)
               {
                  strUpdateSQL += ",SZYLZ='" + model.SZYLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZZZ") == true && model.SZZZ != null)
               {
                  strUpdateSQL += ",SZZZ='" + model.SZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZZLZ") == true && model.SIZZLZ != null)
               {
                  strUpdateSQL += ",SIZZLZ='" + model.SIZZLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZYLZ") == true && model.SIZYLZ != null)
               {
                  strUpdateSQL += ",SIZYLZ='" + model.SIZYLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZZZ") == true && model.SIZZZ != null)
               {
                  strUpdateSQL += ",SIZZZ='" + model.SIZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZZLZ") == true && model.WZZLZ != null)
               {
                  strUpdateSQL += ",WZZLZ='" + model.WZZLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZYLZ") == true && model.WZYLZ != null)
               {
                  strUpdateSQL += ",WZYLZ='" + model.WZYLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZZZ") == true && model.WZZZ != null)
               {
                  strUpdateSQL += ",WZZZ='" + model.WZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZZLZ") == true && model.LZZLZ != null)
               {
                  strUpdateSQL += ",LZZLZ='" + model.LZZLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZYLZ") == true && model.LZYLZ != null)
               {
                  strUpdateSQL += ",LZYLZ='" + model.LZYLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZZZ") == true && model.LZZZ != null)
               {
                  strUpdateSQL += ",LZZZ='" + model.LZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZDTLH") == true && model.YZZDTLH != null)
               {
                  strUpdateSQL += ",YZZDTLH='" + model.YZZDTLH.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZYDTLH") == true && model.YZYDTLH != null)
               {
                  strUpdateSQL += ",YZYDTLH='" + model.YZYDTLH.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZDTLH") == true && model.YZDTLH != null)
               {
                  strUpdateSQL += ",YZDTLH='" + model.YZDTLH.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZDTLH") == true && model.EZZDTLH != null)
               {
                  strUpdateSQL += ",EZZDTLH='" + model.EZZDTLH.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZYDTLH") == true && model.EZYDTLH != null)
               {
                  strUpdateSQL += ",EZYDTLH='" + model.EZYDTLH.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZDTLH") == true && model.EZDTLH != null)
               {
                  strUpdateSQL += ",EZDTLH='" + model.EZDTLH.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZCZLZ") == true && model.ZCZLZ != null)
               {
                  strUpdateSQL += ",ZCZLZ='" + model.ZCZLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZCYLZ") == true && model.ZCYLZ != null)
               {
                  strUpdateSQL += ",ZCYLZ='" + model.ZCYLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZCZZ") == true && model.ZCZZ != null)
               {
                  strUpdateSQL += ",ZCZZ='" + model.ZCZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZZZL") == true && model.YZZZZL != null)
               {
                  strUpdateSQL += ",YZZZZL='" + model.YZZZZL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZYZZL") == true && model.YZYZZL != null)
               {
                  strUpdateSQL += ",YZYZZL='" + model.YZYZZL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZZZLV") == true && model.YZZZZLV != null)
               {
                  strUpdateSQL += ",YZZZZLV='" + model.YZZZZLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZYZZLV") == true && model.YZYZZLV != null)
               {
                  strUpdateSQL += ",YZYZZLV='" + model.YZYZZLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZZZL_PD") == true && model.YZZZZL_PD != null)
               {
                  strUpdateSQL += ",YZZZZL_PD='" + model.YZZZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZYZZL_PD") == true && model.YZYZZL_PD != null)
               {
                  strUpdateSQL += ",YZYZZL_PD='" + model.YZYZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZZL_PD") == true && model.YZZZL_PD != null)
               {
                  strUpdateSQL += ",YZZZL_PD='" + model.YZZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZZZL") == true && model.EZZZZL != null)
               {
                  strUpdateSQL += ",EZZZZL='" + model.EZZZZL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZYZZL") == true && model.EZYZZL != null)
               {
                  strUpdateSQL += ",EZYZZL='" + model.EZYZZL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZZZLV") == true && model.EZZZZLV != null)
               {
                  strUpdateSQL += ",EZZZZLV='" + model.EZZZZLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZYZZLV") == true && model.EZYZZLV != null)
               {
                  strUpdateSQL += ",EZYZZLV='" + model.EZYZZLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZZZL_PD") == true && model.EZZZZL_PD != null)
               {
                  strUpdateSQL += ",EZZZZL_PD='" + model.EZZZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZYZZL_PD") == true && model.EZYZZL_PD != null)
               {
                  strUpdateSQL += ",EZYZZL_PD='" + model.EZYZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZZL_PD") == true && model.EZZZL_PD != null)
               {
                  strUpdateSQL += ",EZZZL_PD='" + model.EZZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZZZZL") == true && model.SZZZZL != null)
               {
                  strUpdateSQL += ",SZZZZL='" + model.SZZZZL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZYZZL") == true && model.SZYZZL != null)
               {
                  strUpdateSQL += ",SZYZZL='" + model.SZYZZL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZZZZLV") == true && model.SZZZZLV != null)
               {
                  strUpdateSQL += ",SZZZZLV='" + model.SZZZZLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZYZZLV") == true && model.SZYZZLV != null)
               {
                  strUpdateSQL += ",SZYZZLV='" + model.SZYZZLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZZZZL_PD") == true && model.SZZZZL_PD != null)
               {
                  strUpdateSQL += ",SZZZZL_PD='" + model.SZZZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZYZZL_PD") == true && model.SZYZZL_PD != null)
               {
                  strUpdateSQL += ",SZYZZL_PD='" + model.SZYZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZZZL_PD") == true && model.SZZZL_PD != null)
               {
                  strUpdateSQL += ",SZZZL_PD='" + model.SZZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZZZZL") == true && model.SIZZZZL != null)
               {
                  strUpdateSQL += ",SIZZZZL='" + model.SIZZZZL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZYZZL") == true && model.SIZYZZL != null)
               {
                  strUpdateSQL += ",SIZYZZL='" + model.SIZYZZL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZZZZLV") == true && model.SIZZZZLV != null)
               {
                  strUpdateSQL += ",SIZZZZLV='" + model.SIZZZZLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZYZZLV") == true && model.SIZYZZLV != null)
               {
                  strUpdateSQL += ",SIZYZZLV='" + model.SIZYZZLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZZZZL_PD") == true && model.SIZZZZL_PD != null)
               {
                  strUpdateSQL += ",SIZZZZL_PD='" + model.SIZZZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZYZZL_PD") == true && model.SIZYZZL_PD != null)
               {
                  strUpdateSQL += ",SIZYZZL_PD='" + model.SIZYZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZZZL_PD") == true && model.SIZZZL_PD != null)
               {
                  strUpdateSQL += ",SIZZZL_PD='" + model.SIZZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZZZZL") == true && model.WZZZZL != null)
               {
                  strUpdateSQL += ",WZZZZL='" + model.WZZZZL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZYZZL") == true && model.WZYZZL != null)
               {
                  strUpdateSQL += ",WZYZZL='" + model.WZYZZL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZZZZLV") == true && model.WZZZZLV != null)
               {
                  strUpdateSQL += ",WZZZZLV='" + model.WZZZZLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZYZZLV") == true && model.WZYZZLV != null)
               {
                  strUpdateSQL += ",WZYZZLV='" + model.WZYZZLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZZZZL_PD") == true && model.WZZZZL_PD != null)
               {
                  strUpdateSQL += ",WZZZZL_PD='" + model.WZZZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZYZZL_PD") == true && model.WZYZZL_PD != null)
               {
                  strUpdateSQL += ",WZYZZL_PD='" + model.WZYZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZZZL_PD") == true && model.WZZZL_PD != null)
               {
                  strUpdateSQL += ",WZZZL_PD='" + model.WZZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZZZZL") == true && model.LZZZZL != null)
               {
                  strUpdateSQL += ",LZZZZL='" + model.LZZZZL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZYZZL") == true && model.LZYZZL != null)
               {
                  strUpdateSQL += ",LZYZZL='" + model.LZYZZL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZZZZLV") == true && model.LZZZZLV != null)
               {
                  strUpdateSQL += ",LZZZZLV='" + model.LZZZZLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZYZZLV") == true && model.LZYZZLV != null)
               {
                  strUpdateSQL += ",LZYZZLV='" + model.LZYZZLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZZZZL_PD") == true && model.LZZZZL_PD != null)
               {
                  strUpdateSQL += ",LZZZZL_PD='" + model.LZZZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZYZZL_PD") == true && model.LZYZZL_PD != null)
               {
                  strUpdateSQL += ",LZYZZL_PD='" + model.LZYZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZZZL_PD") == true && model.LZZZL_PD != null)
               {
                  strUpdateSQL += ",LZZZL_PD='" + model.LZZZL_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZZDCZD") == true && model.YZZZDCZD != null)
               {
                  strUpdateSQL += ",YZZZDCZD='" + model.YZZZDCZD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZYZDCZD") == true && model.YZYZDCZD != null)
               {
                  strUpdateSQL += ",YZYZDCZD='" + model.YZYZDCZD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZBPHLV") == true && model.YZBPHLV != null)
               {
                  strUpdateSQL += ",YZBPHLV='" + model.YZBPHLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZBPHLV_PD") == true && model.YZBPHLV_PD != null)
               {
                  strUpdateSQL += ",YZBPHLV_PD='" + model.YZBPHLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZZDCZD") == true && model.EZZZDCZD != null)
               {
                  strUpdateSQL += ",EZZZDCZD='" + model.EZZZDCZD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZYZDCZD") == true && model.EZYZDCZD != null)
               {
                  strUpdateSQL += ",EZYZDCZD='" + model.EZYZDCZD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZBPHLV") == true && model.EZBPHLV != null)
               {
                  strUpdateSQL += ",EZBPHLV='" + model.EZBPHLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZBPHLV_PD") == true && model.EZBPHLV_PD != null)
               {
                  strUpdateSQL += ",EZBPHLV_PD='" + model.EZBPHLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZZZDCZD") == true && model.SZZZDCZD != null)
               {
                  strUpdateSQL += ",SZZZDCZD='" + model.SZZZDCZD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZYZDCZD") == true && model.SZYZDCZD != null)
               {
                  strUpdateSQL += ",SZYZDCZD='" + model.SZYZDCZD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZBPHLV") == true && model.SZBPHLV != null)
               {
                  strUpdateSQL += ",SZBPHLV='" + model.SZBPHLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZBPHLV_PD") == true && model.SZBPHLV_PD != null)
               {
                  strUpdateSQL += ",SZBPHLV_PD='" + model.SZBPHLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZZZDCZD") == true && model.SIZZZDCZD != null)
               {
                  strUpdateSQL += ",SIZZZDCZD='" + model.SIZZZDCZD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZYZDCZD") == true && model.SIZYZDCZD != null)
               {
                  strUpdateSQL += ",SIZYZDCZD='" + model.SIZYZDCZD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZBPHLV") == true && model.SIZBPHLV != null)
               {
                  strUpdateSQL += ",SIZBPHLV='" + model.SIZBPHLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZBPHLV_PD") == true && model.SIZBPHLV_PD != null)
               {
                  strUpdateSQL += ",SIZBPHLV_PD='" + model.SIZBPHLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZZZDCZD") == true && model.WZZZDCZD != null)
               {
                  strUpdateSQL += ",WZZZDCZD='" + model.WZZZDCZD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZYZDCZD") == true && model.WZYZDCZD != null)
               {
                  strUpdateSQL += ",WZYZDCZD='" + model.WZYZDCZD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZBPHLV") == true && model.WZBPHLV != null)
               {
                  strUpdateSQL += ",WZBPHLV='" + model.WZBPHLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZBPHLV_PD") == true && model.WZBPHLV_PD != null)
               {
                  strUpdateSQL += ",WZBPHLV_PD='" + model.WZBPHLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZZZDCZD") == true && model.LZZZDCZD != null)
               {
                  strUpdateSQL += ",LZZZDCZD='" + model.LZZZDCZD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZYZDCZD") == true && model.LZYZDCZD != null)
               {
                  strUpdateSQL += ",LZYZDCZD='" + model.LZYZDCZD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZBPHLV") == true && model.LZBPHLV != null)
               {
                  strUpdateSQL += ",LZBPHLV='" + model.LZBPHLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZBPHLV_PD") == true && model.LZBPHLV_PD != null)
               {
                  strUpdateSQL += ",LZBPHLV_PD='" + model.LZBPHLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZZDZDL") == true && model.YZZZDZDL != null)
               {
                  strUpdateSQL += ",YZZZDZDL='" + model.YZZZDZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZYZDZDL") == true && model.YZYZDZDL != null)
               {
                  strUpdateSQL += ",YZYZDZDL='" + model.YZYZDZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZDLV") == true && model.YZZDLV != null)
               {
                  strUpdateSQL += ",YZZDLV='" + model.YZZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZDLV_PD") == true && model.YZZDLV_PD != null)
               {
                  strUpdateSQL += ",YZZDLV_PD='" + model.YZZDLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZZDZDL") == true && model.EZZZDZDL != null)
               {
                  strUpdateSQL += ",EZZZDZDL='" + model.EZZZDZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZYZDZDL") == true && model.EZYZDZDL != null)
               {
                  strUpdateSQL += ",EZYZDZDL='" + model.EZYZDZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZDLV") == true && model.EZZDLV != null)
               {
                  strUpdateSQL += ",EZZDLV='" + model.EZZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZDLV_PD") == true && model.EZZDLV_PD != null)
               {
                  strUpdateSQL += ",EZZDLV_PD='" + model.EZZDLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZZZDZDL") == true && model.SZZZDZDL != null)
               {
                  strUpdateSQL += ",SZZZDZDL='" + model.SZZZDZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZYZDZDL") == true && model.SZYZDZDL != null)
               {
                  strUpdateSQL += ",SZYZDZDL='" + model.SZYZDZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZZDLV") == true && model.SZZDLV != null)
               {
                  strUpdateSQL += ",SZZDLV='" + model.SZZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZZDLV_PD") == true && model.SZZDLV_PD != null)
               {
                  strUpdateSQL += ",SZZDLV_PD='" + model.SZZDLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZZZDZDL") == true && model.SIZZZDZDL != null)
               {
                  strUpdateSQL += ",SIZZZDZDL='" + model.SIZZZDZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZYZDZDL") == true && model.SIZYZDZDL != null)
               {
                  strUpdateSQL += ",SIZYZDZDL='" + model.SIZYZDZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZZDLV") == true && model.SIZZDLV != null)
               {
                  strUpdateSQL += ",SIZZDLV='" + model.SIZZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZZDLV_PD") == true && model.SIZZDLV_PD != null)
               {
                  strUpdateSQL += ",SIZZDLV_PD='" + model.SIZZDLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZZZDZDL") == true && model.WZZZDZDL != null)
               {
                  strUpdateSQL += ",WZZZDZDL='" + model.WZZZDZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZYZDZDL") == true && model.WZYZDZDL != null)
               {
                  strUpdateSQL += ",WZYZDZDL='" + model.WZYZDZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZZDLV") == true && model.WZZDLV != null)
               {
                  strUpdateSQL += ",WZZDLV='" + model.WZZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZZDLV_PD") == true && model.WZZDLV_PD != null)
               {
                  strUpdateSQL += ",WZZDLV_PD='" + model.WZZDLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZZZDZDL") == true && model.LZZZDZDL != null)
               {
                  strUpdateSQL += ",LZZZDZDL='" + model.LZZZDZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZYZDZDL") == true && model.LZYZDZDL != null)
               {
                  strUpdateSQL += ",LZYZDZDL='" + model.LZYZDZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZZDLV") == true && model.LZZDLV != null)
               {
                  strUpdateSQL += ",LZZDLV='" + model.LZZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZZDLV_PD") == true && model.LZZDLV_PD != null)
               {
                  strUpdateSQL += ",LZZDLV_PD='" + model.LZZDLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZSZDL") == true && model.YZZSZDL != null)
               {
                  strUpdateSQL += ",YZZSZDL='" + model.YZZSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZYSZDL") == true && model.YZYSZDL != null)
               {
                  strUpdateSQL += ",YZYSZDL='" + model.YZYSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZSZDL") == true && model.YZSZDL != null)
               {
                  strUpdateSQL += ",YZSZDL='" + model.YZSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZSZDL") == true && model.EZZSZDL != null)
               {
                  strUpdateSQL += ",EZZSZDL='" + model.EZZSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZYSZDL") == true && model.EZYSZDL != null)
               {
                  strUpdateSQL += ",EZYSZDL='" + model.EZYSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZSZDL") == true && model.EZSZDL != null)
               {
                  strUpdateSQL += ",EZSZDL='" + model.EZSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZZSZDL") == true && model.SZZSZDL != null)
               {
                  strUpdateSQL += ",SZZSZDL='" + model.SZZSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZYSZDL") == true && model.SZYSZDL != null)
               {
                  strUpdateSQL += ",SZYSZDL='" + model.SZYSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZSZDL") == true && model.SZSZDL != null)
               {
                  strUpdateSQL += ",SZSZDL='" + model.SZSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZZSZDL") == true && model.SIZZSZDL != null)
               {
                  strUpdateSQL += ",SIZZSZDL='" + model.SIZZSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZYSZDL") == true && model.SIZYSZDL != null)
               {
                  strUpdateSQL += ",SIZYSZDL='" + model.SIZYSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZSZDL") == true && model.SIZSZDL != null)
               {
                  strUpdateSQL += ",SIZSZDL='" + model.SIZSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZZSZDL") == true && model.WZZSZDL != null)
               {
                  strUpdateSQL += ",WZZSZDL='" + model.WZZSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZYSZDL") == true && model.WZYSZDL != null)
               {
                  strUpdateSQL += ",WZYSZDL='" + model.WZYSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZSZDL") == true && model.WZSZDL != null)
               {
                  strUpdateSQL += ",WZSZDL='" + model.WZSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZZSZDL") == true && model.LZZSZDL != null)
               {
                  strUpdateSQL += ",LZZSZDL='" + model.LZZSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZYSZDL") == true && model.LZYSZDL != null)
               {
                  strUpdateSQL += ",LZYSZDL='" + model.LZYSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZSZDL") == true && model.LZSZDL != null)
               {
                  strUpdateSQL += ",LZSZDL='" + model.LZSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZZSZDL") == true && model.ZZSZDL != null)
               {
                  strUpdateSQL += ",ZZSZDL='" + model.ZZSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZYSZDL") == true && model.ZYSZDL != null)
               {
                  strUpdateSQL += ",ZYSZDL='" + model.ZYSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZSZDL") == true && model.ZSZDL != null)
               {
                  strUpdateSQL += ",ZSZDL='" + model.ZSZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZCSZDLV") == true && model.ZCSZDLV != null)
               {
                  strUpdateSQL += ",ZCSZDLV='" + model.ZCSZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZDLV_PD") == true && model.SZDLV_PD != null)
               {
                  strUpdateSQL += ",SZDLV_PD='" + model.SZDLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZCZDL") == true && model.ZCZDL != null)
               {
                  strUpdateSQL += ",ZCZDL='" + model.ZCZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZCZDLV") == true && model.ZCZDLV != null)
               {
                  strUpdateSQL += ",ZCZDLV='" + model.ZCZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZCZDLV_PD") == true && model.ZCZDLV_PD != null)
               {
                  strUpdateSQL += ",ZCZDLV_PD='" + model.ZCZDLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZJZZZ") == true && model.YZJZZZ != null)
               {
                  strUpdateSQL += ",YZJZZZ='" + model.YZJZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZJZZZ") == true && model.EZJZZZ != null)
               {
                  strUpdateSQL += ",EZJZZZ='" + model.EZJZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZJZZZ") == true && model.SZJZZZ != null)
               {
                  strUpdateSQL += ",SZJZZZ='" + model.SZJZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZJZZZ") == true && model.SIZJZZZ != null)
               {
                  strUpdateSQL += ",SIZJZZZ='" + model.SIZJZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZJZZZ") == true && model.WZJZZZ != null)
               {
                  strUpdateSQL += ",WZJZZZ='" + model.WZJZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZJZZZ") == true && model.LZJZZZ != null)
               {
                  strUpdateSQL += ",LZJZZZ='" + model.LZJZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZJZZDLV") == true && model.YZJZZDLV != null)
               {
                  strUpdateSQL += ",YZJZZDLV='" + model.YZJZZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZJZZDLV_PD") == true && model.YZJZZDLV_PD != null)
               {
                  strUpdateSQL += ",YZJZZDLV_PD='" + model.YZJZZDLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZJZZDLV") == true && model.EZJZZDLV != null)
               {
                  strUpdateSQL += ",EZJZZDLV='" + model.EZJZZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZJZZDLV_PD") == true && model.EZJZZDLV_PD != null)
               {
                  strUpdateSQL += ",EZJZZDLV_PD='" + model.EZJZZDLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZJZZDLV") == true && model.SZJZZDLV != null)
               {
                  strUpdateSQL += ",SZJZZDLV='" + model.SZJZZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZJZZDLV_PD") == true && model.SZJZZDLV_PD != null)
               {
                  strUpdateSQL += ",SZJZZDLV_PD='" + model.SZJZZDLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZJZZDLV") == true && model.SIZJZZDLV != null)
               {
                  strUpdateSQL += ",SIZJZZDLV='" + model.SIZJZZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZJZZDLV_PD") == true && model.SIZJZZDLV_PD != null)
               {
                  strUpdateSQL += ",SIZJZZDLV_PD='" + model.SIZJZZDLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZJZZDLV") == true && model.WZJZZDLV != null)
               {
                  strUpdateSQL += ",WZJZZDLV='" + model.WZJZZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZJZZDLV_PD") == true && model.WZJZZDLV_PD != null)
               {
                  strUpdateSQL += ",WZJZZDLV_PD='" + model.WZJZZDLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZJZZDLV") == true && model.LZJZZDLV != null)
               {
                  strUpdateSQL += ",LZJZZDLV='" + model.LZJZZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZJZZDLV_PD") == true && model.LZJZZDLV_PD != null)
               {
                  strUpdateSQL += ",LZJZZDLV_PD='" + model.LZJZZDLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZJZBPHLV") == true && model.YZJZBPHLV != null)
               {
                  strUpdateSQL += ",YZJZBPHLV='" + model.YZJZBPHLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZJZBPHLV_PD") == true && model.YZJZBPHLV_PD != null)
               {
                  strUpdateSQL += ",YZJZBPHLV_PD='" + model.YZJZBPHLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZJZBPHLV") == true && model.EZJZBPHLV != null)
               {
                  strUpdateSQL += ",EZJZBPHLV='" + model.EZJZBPHLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZJZBPHLV_PD") == true && model.EZJZBPHLV_PD != null)
               {
                  strUpdateSQL += ",EZJZBPHLV_PD='" + model.EZJZBPHLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZJZBPHLV") == true && model.SZJZBPHLV != null)
               {
                  strUpdateSQL += ",SZJZBPHLV='" + model.SZJZBPHLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZJZBPHLV_PD") == true && model.SZJZBPHLV_PD != null)
               {
                  strUpdateSQL += ",SZJZBPHLV_PD='" + model.SZJZBPHLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZJZBPHLV") == true && model.SIZJZBPHLV != null)
               {
                  strUpdateSQL += ",SIZJZBPHLV='" + model.SIZJZBPHLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZJZBPHLV_PD") == true && model.SIZJZBPHLV_PD != null)
               {
                  strUpdateSQL += ",SIZJZBPHLV_PD='" + model.SIZJZBPHLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZJZBPHLV") == true && model.WZJZBPHLV != null)
               {
                  strUpdateSQL += ",WZJZBPHLV='" + model.WZJZBPHLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZJZBPHLV_PD") == true && model.WZJZBPHLV_PD != null)
               {
                  strUpdateSQL += ",WZJZBPHLV_PD='" + model.WZJZBPHLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZJZBPHLV") == true && model.LZJZBPHLV != null)
               {
                  strUpdateSQL += ",LZJZBPHLV='" + model.LZJZBPHLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZJZBPHLV_PD") == true && model.LZJZBPHLV_PD != null)
               {
                  strUpdateSQL += ",LZJZBPHLV_PD='" + model.LZJZBPHLV_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZDZ_PD") == true && model.YZZDZ_PD != null)
               {
                  strUpdateSQL += ",YZZDZ_PD='" + model.YZZDZ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZDZ_PD") == true && model.EZZDZ_PD != null)
               {
                  strUpdateSQL += ",EZZDZ_PD='" + model.EZZDZ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZZDZ_PD") == true && model.SZZDZ_PD != null)
               {
                  strUpdateSQL += ",SZZDZ_PD='" + model.SZZDZ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZZDZ_PD") == true && model.SIZZDZ_PD != null)
               {
                  strUpdateSQL += ",SIZZDZ_PD='" + model.SIZZDZ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZZDZ_PD") == true && model.WZZDZ_PD != null)
               {
                  strUpdateSQL += ",WZZDZ_PD='" + model.WZZDZ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZZDZ_PD") == true && model.LZZDZ_PD != null)
               {
                  strUpdateSQL += ",LZZDZ_PD='" + model.LZZDZ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZZLVXZBZ") == true && model.YZZZLVXZBZ != null)
               {
                  strUpdateSQL += ",YZZZLVXZBZ='" + model.YZZZLVXZBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZZLVXZBZ") == true && model.EZZZLVXZBZ != null)
               {
                  strUpdateSQL += ",EZZZLVXZBZ='" + model.EZZZLVXZBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZZZLVXZBZ") == true && model.SZZZLVXZBZ != null)
               {
                  strUpdateSQL += ",SZZZLVXZBZ='" + model.SZZZLVXZBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZZZLVXZBZ") == true && model.SIZZZLVXZBZ != null)
               {
                  strUpdateSQL += ",SIZZZLVXZBZ='" + model.SIZZZLVXZBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZZZLVXZBZ") == true && model.WZZZLVXZBZ != null)
               {
                  strUpdateSQL += ",WZZZLVXZBZ='" + model.WZZZLVXZBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZZZLVXZBZ") == true && model.LZZZLVXZBZ != null)
               {
                  strUpdateSQL += ",LZZZLVXZBZ='" + model.LZZZLVXZBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZBPHLVBZ") == true && model.YZBPHLVBZ != null)
               {
                  strUpdateSQL += ",YZBPHLVBZ='" + model.YZBPHLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZBPHLVBZ") == true && model.EZBPHLVBZ != null)
               {
                  strUpdateSQL += ",EZBPHLVBZ='" + model.EZBPHLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZBPHLVBZ") == true && model.SZBPHLVBZ != null)
               {
                  strUpdateSQL += ",SZBPHLVBZ='" + model.SZBPHLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZBPHLVBZ") == true && model.SIZBPHLVBZ != null)
               {
                  strUpdateSQL += ",SIZBPHLVBZ='" + model.SIZBPHLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZBPHLVBZ") == true && model.WZBPHLVBZ != null)
               {
                  strUpdateSQL += ",WZBPHLVBZ='" + model.WZBPHLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZBPHLVBZ") == true && model.LZBPHLVBZ != null)
               {
                  strUpdateSQL += ",LZBPHLVBZ='" + model.LZBPHLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZZDLVBZ") == true && model.YZZDLVBZ != null)
               {
                  strUpdateSQL += ",YZZDLVBZ='" + model.YZZDLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZZDLVBZ") == true && model.EZZDLVBZ != null)
               {
                  strUpdateSQL += ",EZZDLVBZ='" + model.EZZDLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZZDLVBZ") == true && model.SZZDLVBZ != null)
               {
                  strUpdateSQL += ",SZZDLVBZ='" + model.SZZDLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZZDLVBZ") == true && model.SIZZDLVBZ != null)
               {
                  strUpdateSQL += ",SIZZDLVBZ='" + model.SIZZDLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZZDLVBZ") == true && model.WZZDLVBZ != null)
               {
                  strUpdateSQL += ",WZZDLVBZ='" + model.WZZDLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZZDLVBZ") == true && model.LZZDLVBZ != null)
               {
                  strUpdateSQL += ",LZZDLVBZ='" + model.LZZDLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZDLVBZ") == true && model.SZDLVBZ != null)
               {
                  strUpdateSQL += ",SZDLVBZ='" + model.SZDLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZCZDLVBZ") == true && model.ZCZDLVBZ != null)
               {
                  strUpdateSQL += ",ZCZDLVBZ='" + model.ZCZDLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("QCLCZCBZ") == true && model.QCLCZCBZ != null)
               {
                  strUpdateSQL += ",QCLCZCBZ='" + model.QCLCZCBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("QCLCZC_PD") == true && model.QCLCZC_PD != null)
               {
                  strUpdateSQL += ",QCLCZC_PD='" + model.QCLCZC_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("QCLCZCZDLV") == true && model.QCLCZCZDLV != null)
               {
                  strUpdateSQL += ",QCLCZCZDLV='" + model.QCLCZCZDLV.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZZCZDL") == true && model.ZZCZDL != null)
               {
                  strUpdateSQL += ",ZZCZDL='" + model.ZZCZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZCZDL") == true && model.YZCZDL != null)
               {
                  strUpdateSQL += ",YZCZDL='" + model.YZCZDL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("QZBPHLVBZ") == true && model.QZBPHLVBZ != null)
               {
                  strUpdateSQL += ",QZBPHLVBZ='" + model.QZBPHLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("HZBPHLVBZDY60") == true && model.HZBPHLVBZDY60 != null)
               {
                  strUpdateSQL += ",HZBPHLVBZDY60='" + model.HZBPHLVBZDY60.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("HZBPHLVBZXY60") == true && model.HZBPHLVBZXY60 != null)
               {
                  strUpdateSQL += ",HZBPHLVBZXY60='" + model.HZBPHLVBZXY60.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTYZZZ") == true && model.FHTYZZZ != null)
               {
                  strUpdateSQL += ",FHTYZZZ='" + model.FHTYZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTYZZLZ") == true && model.FHTYZZLZ != null)
               {
                  strUpdateSQL += ",FHTYZZLZ='" + model.FHTYZZLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTYZYLZ") == true && model.FHTYZYLZ != null)
               {
                  strUpdateSQL += ",FHTYZYLZ='" + model.FHTYZYLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTEZZZ") == true && model.FHTEZZZ != null)
               {
                  strUpdateSQL += ",FHTEZZZ='" + model.FHTEZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTEZZLZ") == true && model.FHTEZZLZ != null)
               {
                  strUpdateSQL += ",FHTEZZLZ='" + model.FHTEZZLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTEZYLZ") == true && model.FHTEZYLZ != null)
               {
                  strUpdateSQL += ",FHTEZYLZ='" + model.FHTEZYLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTSZZZ") == true && model.FHTSZZZ != null)
               {
                  strUpdateSQL += ",FHTSZZZ='" + model.FHTSZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTSZZLZ") == true && model.FHTSZZLZ != null)
               {
                  strUpdateSQL += ",FHTSZZLZ='" + model.FHTSZZLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTSZYLZ") == true && model.FHTSZYLZ != null)
               {
                  strUpdateSQL += ",FHTSZYLZ='" + model.FHTSZYLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTSIZZZ") == true && model.FHTSIZZZ != null)
               {
                  strUpdateSQL += ",FHTSIZZZ='" + model.FHTSIZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTSIZZLZ") == true && model.FHTSIZZLZ != null)
               {
                  strUpdateSQL += ",FHTSIZZLZ='" + model.FHTSIZZLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTSIZYLZ") == true && model.FHTSIZYLZ != null)
               {
                  strUpdateSQL += ",FHTSIZYLZ='" + model.FHTSIZYLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTWZZZ") == true && model.FHTWZZZ != null)
               {
                  strUpdateSQL += ",FHTWZZZ='" + model.FHTWZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTWZZLZ") == true && model.FHTWZZLZ != null)
               {
                  strUpdateSQL += ",FHTWZZLZ='" + model.FHTWZZLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTWZYLZ") == true && model.FHTWZYLZ != null)
               {
                  strUpdateSQL += ",FHTWZYLZ='" + model.FHTWZYLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTLZZZ") == true && model.FHTLZZZ != null)
               {
                  strUpdateSQL += ",FHTLZZZ='" + model.FHTLZZZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTLZZLZ") == true && model.FHTLZZLZ != null)
               {
                  strUpdateSQL += ",FHTLZZLZ='" + model.FHTLZZLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("FHTLZYLZ") == true && model.FHTLZYLZ != null)
               {
                  strUpdateSQL += ",FHTLZYLZ='" + model.FHTLZYLZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YZJZZDLVBZ") == true && model.YZJZZDLVBZ != null)
               {
                  strUpdateSQL += ",YZJZZDLVBZ='" + model.YZJZZDLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("EZJZZDLVBZ") == true && model.EZJZZDLVBZ != null)
               {
                  strUpdateSQL += ",EZJZZDLVBZ='" + model.EZJZZDLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SZJZZDLVBZ") == true && model.SZJZZDLVBZ != null)
               {
                  strUpdateSQL += ",SZJZZDLVBZ='" + model.SZJZZDLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("SIZJZZDLVBZ") == true && model.SIZJZZDLVBZ != null)
               {
                  strUpdateSQL += ",SIZJZZDLVBZ='" + model.SIZJZZDLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("WZJZZDLVBZ") == true && model.WZJZZDLVBZ != null)
               {
                  strUpdateSQL += ",WZJZZDLVBZ='" + model.WZJZZDLVBZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("LZJZZDLVBZ") == true && model.LZJZZDLVBZ != null)
               {
                  strUpdateSQL += ",LZJZZDLVBZ='" + model.LZJZZDLVBZ.ToString().Replace("'","''") + "'";
               }

              string strSql = "";
              strSql += "update RESULT_BRAKE set ";
              strSql += strUpdateSQL.Substring(1);
              strSql += " where " + p_strWhere;

              return strSql;
          }

          /// <summary>
          /// 修改一个集合
          /// </summary>
          public bool UpdateRange(RESULT_BRAKE model, string p_strWhere)
          {
              return DbHelper.ExecuteSql(UpdateRangeSQL(model, p_strWhere));
          }

          /// <summary>
          /// 修改全部数据 SQL
          /// </summary>
          public string UpdateAllSQL(RESULT_BRAKE model)
          {
              string strUpdateSQL = "";

                  strUpdateSQL += ",ID=" + model.ID + "";
                  strUpdateSQL += ",ZDYZJCCS='" + model.ZDYZJCCS.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZDEZJCCS='" + model.ZDEZJCCS.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZDSZJCCS='" + model.ZDSZJCCS.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZDSIZJCCS='" + model.ZDSIZJCCS.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZDWZJCCS='" + model.ZDWZJCCS.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZDLZJCCS='" + model.ZDLZJCCS.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZDSZDJCCS='" + model.ZDSZDJCCS.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZDZCJCCS='" + model.ZDZCJCCS.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",JCLSH='" + model.JCLSH.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZLZ='" + model.YZZLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZYLZ='" + model.YZYLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZZ='" + model.YZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZLZ='" + model.EZZLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZYLZ='" + model.EZYLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZZ='" + model.EZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZZLZ='" + model.SZZLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZYLZ='" + model.SZYLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZZZ='" + model.SZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZZLZ='" + model.SIZZLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZYLZ='" + model.SIZYLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZZZ='" + model.SIZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZZLZ='" + model.WZZLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZYLZ='" + model.WZYLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZZZ='" + model.WZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZZLZ='" + model.LZZLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZYLZ='" + model.LZYLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZZZ='" + model.LZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZDTLH='" + model.YZZDTLH.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZYDTLH='" + model.YZYDTLH.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZDTLH='" + model.YZDTLH.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZDTLH='" + model.EZZDTLH.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZYDTLH='" + model.EZYDTLH.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZDTLH='" + model.EZDTLH.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZCZLZ='" + model.ZCZLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZCYLZ='" + model.ZCYLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZCZZ='" + model.ZCZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZZZL='" + model.YZZZZL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZYZZL='" + model.YZYZZL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZZZLV='" + model.YZZZZLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZYZZLV='" + model.YZYZZLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZZZL_PD='" + model.YZZZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZYZZL_PD='" + model.YZYZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZZL_PD='" + model.YZZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZZZL='" + model.EZZZZL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZYZZL='" + model.EZYZZL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZZZLV='" + model.EZZZZLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZYZZLV='" + model.EZYZZLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZZZL_PD='" + model.EZZZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZYZZL_PD='" + model.EZYZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZZL_PD='" + model.EZZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZZZZL='" + model.SZZZZL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZYZZL='" + model.SZYZZL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZZZZLV='" + model.SZZZZLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZYZZLV='" + model.SZYZZLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZZZZL_PD='" + model.SZZZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZYZZL_PD='" + model.SZYZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZZZL_PD='" + model.SZZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZZZZL='" + model.SIZZZZL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZYZZL='" + model.SIZYZZL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZZZZLV='" + model.SIZZZZLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZYZZLV='" + model.SIZYZZLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZZZZL_PD='" + model.SIZZZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZYZZL_PD='" + model.SIZYZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZZZL_PD='" + model.SIZZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZZZZL='" + model.WZZZZL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZYZZL='" + model.WZYZZL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZZZZLV='" + model.WZZZZLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZYZZLV='" + model.WZYZZLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZZZZL_PD='" + model.WZZZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZYZZL_PD='" + model.WZYZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZZZL_PD='" + model.WZZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZZZZL='" + model.LZZZZL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZYZZL='" + model.LZYZZL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZZZZLV='" + model.LZZZZLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZYZZLV='" + model.LZYZZLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZZZZL_PD='" + model.LZZZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZYZZL_PD='" + model.LZYZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZZZL_PD='" + model.LZZZL_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZZDCZD='" + model.YZZZDCZD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZYZDCZD='" + model.YZYZDCZD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZBPHLV='" + model.YZBPHLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZBPHLV_PD='" + model.YZBPHLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZZDCZD='" + model.EZZZDCZD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZYZDCZD='" + model.EZYZDCZD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZBPHLV='" + model.EZBPHLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZBPHLV_PD='" + model.EZBPHLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZZZDCZD='" + model.SZZZDCZD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZYZDCZD='" + model.SZYZDCZD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZBPHLV='" + model.SZBPHLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZBPHLV_PD='" + model.SZBPHLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZZZDCZD='" + model.SIZZZDCZD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZYZDCZD='" + model.SIZYZDCZD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZBPHLV='" + model.SIZBPHLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZBPHLV_PD='" + model.SIZBPHLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZZZDCZD='" + model.WZZZDCZD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZYZDCZD='" + model.WZYZDCZD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZBPHLV='" + model.WZBPHLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZBPHLV_PD='" + model.WZBPHLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZZZDCZD='" + model.LZZZDCZD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZYZDCZD='" + model.LZYZDCZD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZBPHLV='" + model.LZBPHLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZBPHLV_PD='" + model.LZBPHLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZZDZDL='" + model.YZZZDZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZYZDZDL='" + model.YZYZDZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZDLV='" + model.YZZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZDLV_PD='" + model.YZZDLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZZDZDL='" + model.EZZZDZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZYZDZDL='" + model.EZYZDZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZDLV='" + model.EZZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZDLV_PD='" + model.EZZDLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZZZDZDL='" + model.SZZZDZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZYZDZDL='" + model.SZYZDZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZZDLV='" + model.SZZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZZDLV_PD='" + model.SZZDLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZZZDZDL='" + model.SIZZZDZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZYZDZDL='" + model.SIZYZDZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZZDLV='" + model.SIZZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZZDLV_PD='" + model.SIZZDLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZZZDZDL='" + model.WZZZDZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZYZDZDL='" + model.WZYZDZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZZDLV='" + model.WZZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZZDLV_PD='" + model.WZZDLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZZZDZDL='" + model.LZZZDZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZYZDZDL='" + model.LZYZDZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZZDLV='" + model.LZZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZZDLV_PD='" + model.LZZDLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZSZDL='" + model.YZZSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZYSZDL='" + model.YZYSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZSZDL='" + model.YZSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZSZDL='" + model.EZZSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZYSZDL='" + model.EZYSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZSZDL='" + model.EZSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZZSZDL='" + model.SZZSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZYSZDL='" + model.SZYSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZSZDL='" + model.SZSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZZSZDL='" + model.SIZZSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZYSZDL='" + model.SIZYSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZSZDL='" + model.SIZSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZZSZDL='" + model.WZZSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZYSZDL='" + model.WZYSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZSZDL='" + model.WZSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZZSZDL='" + model.LZZSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZYSZDL='" + model.LZYSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZSZDL='" + model.LZSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZZSZDL='" + model.ZZSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZYSZDL='" + model.ZYSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZSZDL='" + model.ZSZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZCSZDLV='" + model.ZCSZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZDLV_PD='" + model.SZDLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZCZDL='" + model.ZCZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZCZDLV='" + model.ZCZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZCZDLV_PD='" + model.ZCZDLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZJZZZ='" + model.YZJZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZJZZZ='" + model.EZJZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZJZZZ='" + model.SZJZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZJZZZ='" + model.SIZJZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZJZZZ='" + model.WZJZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZJZZZ='" + model.LZJZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZJZZDLV='" + model.YZJZZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZJZZDLV_PD='" + model.YZJZZDLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZJZZDLV='" + model.EZJZZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZJZZDLV_PD='" + model.EZJZZDLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZJZZDLV='" + model.SZJZZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZJZZDLV_PD='" + model.SZJZZDLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZJZZDLV='" + model.SIZJZZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZJZZDLV_PD='" + model.SIZJZZDLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZJZZDLV='" + model.WZJZZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZJZZDLV_PD='" + model.WZJZZDLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZJZZDLV='" + model.LZJZZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZJZZDLV_PD='" + model.LZJZZDLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZJZBPHLV='" + model.YZJZBPHLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZJZBPHLV_PD='" + model.YZJZBPHLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZJZBPHLV='" + model.EZJZBPHLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZJZBPHLV_PD='" + model.EZJZBPHLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZJZBPHLV='" + model.SZJZBPHLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZJZBPHLV_PD='" + model.SZJZBPHLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZJZBPHLV='" + model.SIZJZBPHLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZJZBPHLV_PD='" + model.SIZJZBPHLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZJZBPHLV='" + model.WZJZBPHLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZJZBPHLV_PD='" + model.WZJZBPHLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZJZBPHLV='" + model.LZJZBPHLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZJZBPHLV_PD='" + model.LZJZBPHLV_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZDZ_PD='" + model.YZZDZ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZDZ_PD='" + model.EZZDZ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZZDZ_PD='" + model.SZZDZ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZZDZ_PD='" + model.SIZZDZ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZZDZ_PD='" + model.WZZDZ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZZDZ_PD='" + model.LZZDZ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZZLVXZBZ='" + model.YZZZLVXZBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZZLVXZBZ='" + model.EZZZLVXZBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZZZLVXZBZ='" + model.SZZZLVXZBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZZZLVXZBZ='" + model.SIZZZLVXZBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZZZLVXZBZ='" + model.WZZZLVXZBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZZZLVXZBZ='" + model.LZZZLVXZBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZBPHLVBZ='" + model.YZBPHLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZBPHLVBZ='" + model.EZBPHLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZBPHLVBZ='" + model.SZBPHLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZBPHLVBZ='" + model.SIZBPHLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZBPHLVBZ='" + model.WZBPHLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZBPHLVBZ='" + model.LZBPHLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZZDLVBZ='" + model.YZZDLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZZDLVBZ='" + model.EZZDLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZZDLVBZ='" + model.SZZDLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZZDLVBZ='" + model.SIZZDLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZZDLVBZ='" + model.WZZDLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZZDLVBZ='" + model.LZZDLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZDLVBZ='" + model.SZDLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZCZDLVBZ='" + model.ZCZDLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",QCLCZCBZ='" + model.QCLCZCBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",QCLCZC_PD='" + model.QCLCZC_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",QCLCZCZDLV='" + model.QCLCZCZDLV.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZZCZDL='" + model.ZZCZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZCZDL='" + model.YZCZDL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",QZBPHLVBZ='" + model.QZBPHLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",HZBPHLVBZDY60='" + model.HZBPHLVBZDY60.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",HZBPHLVBZXY60='" + model.HZBPHLVBZXY60.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTYZZZ='" + model.FHTYZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTYZZLZ='" + model.FHTYZZLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTYZYLZ='" + model.FHTYZYLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTEZZZ='" + model.FHTEZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTEZZLZ='" + model.FHTEZZLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTEZYLZ='" + model.FHTEZYLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTSZZZ='" + model.FHTSZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTSZZLZ='" + model.FHTSZZLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTSZYLZ='" + model.FHTSZYLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTSIZZZ='" + model.FHTSIZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTSIZZLZ='" + model.FHTSIZZLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTSIZYLZ='" + model.FHTSIZYLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTWZZZ='" + model.FHTWZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTWZZLZ='" + model.FHTWZZLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTWZYLZ='" + model.FHTWZYLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTLZZZ='" + model.FHTLZZZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTLZZLZ='" + model.FHTLZZLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",FHTLZYLZ='" + model.FHTLZYLZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YZJZZDLVBZ='" + model.YZJZZDLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",EZJZZDLVBZ='" + model.EZJZZDLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SZJZZDLVBZ='" + model.SZJZZDLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",SIZJZZDLVBZ='" + model.SIZJZZDLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",WZJZZDLVBZ='" + model.WZJZZDLVBZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",LZJZZDLVBZ='" + model.LZJZZDLVBZ.ToString().Replace("'","''") + "'";


               string strSql = "";
               strSql += "update RESULT_BRAKE set ";
               strSql += strUpdateSQL.Substring(1);

               return strSql;

          }

          /// <summary>
          /// 修改全部数据
          /// </summary>
          public bool UpdateAll(RESULT_BRAKE model)
          {
              return DbHelper.ExecuteSql(UpdateAllSQL(model));
          }

          /// <summary>
          /// 删除一条数据 SQL
          /// </summary>
          public string DeleteSQL(string strJCLSH)
          {
              string strSql = "";
              strSql += "delete from RESULT_BRAKE";
              strSql += " where ";
               strSql += " JCLSH='"+ strJCLSH +"'";

              return strSql;

          }

          /// <summary>
          /// 删除一条数据
          /// </summary>
          public bool Delete(string strJCLSH)
          {
              return DbHelper.ExecuteSql(DeleteSQL(strJCLSH));
          }

          /// <summary>
          /// 删除一个集合 SQL
          /// </summary>
          public string DeleteRangeSQL(string p_strWhere)
          {
              string strSql = "";
              strSql += "delete from RESULT_BRAKE";
              strSql += " where " + p_strWhere;

              return strSql;
           }

          /// <summary>
          /// 删除一个集合
          /// </summary>
          public bool DeleteRange(string p_strWhere)
          {
              return DbHelper.ExecuteSql(DeleteRangeSQL(p_strWhere));
          }

          /// <summary>
          /// 删除全部 SQL
          /// </summary>
          public string DeleteAllSQL()
          {
              string strSql = "";
              strSql += "delete from RESULT_BRAKE";

              return strSql;
           }

         /// <summary>
         /// 删除全部
         /// </summary>
         public bool DeleteAll()
         {
             return DbHelper.ExecuteSql(DeleteAllSQL());
         }

          /// <summary>
         /// 得到一个对象实体
         /// </summary>
         public RESULT_BRAKE GetModel(string strJCLSH)
         {
             string strSql = "";
             strSql += "select * from RESULT_BRAKE";
             strSql += " where ";
               strSql += " JCLSH='"+ strJCLSH +"'";

             DataTable dtTemp = new DataTable();
             DbHelper.GetTable(strSql, ref dtTemp);

             RESULT_BRAKE model = new RESULT_BRAKE();

             if(dtTemp.Rows.Count>0)
             {
                 model = new RESULT_BRAKE();

                 model.ID = dtTemp.Rows[0]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[0]["ID"]);
                 model.ZDYZJCCS = dtTemp.Rows[0]["ZDYZJCCS"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZDYZJCCS"].ToString();
                 model.ZDEZJCCS = dtTemp.Rows[0]["ZDEZJCCS"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZDEZJCCS"].ToString();
                 model.ZDSZJCCS = dtTemp.Rows[0]["ZDSZJCCS"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZDSZJCCS"].ToString();
                 model.ZDSIZJCCS = dtTemp.Rows[0]["ZDSIZJCCS"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZDSIZJCCS"].ToString();
                 model.ZDWZJCCS = dtTemp.Rows[0]["ZDWZJCCS"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZDWZJCCS"].ToString();
                 model.ZDLZJCCS = dtTemp.Rows[0]["ZDLZJCCS"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZDLZJCCS"].ToString();
                 model.ZDSZDJCCS = dtTemp.Rows[0]["ZDSZDJCCS"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZDSZDJCCS"].ToString();
                 model.ZDZCJCCS = dtTemp.Rows[0]["ZDZCJCCS"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZDZCJCCS"].ToString();
                 model.JCLSH = dtTemp.Rows[0]["JCLSH"] == DBNull.Value ? "" : dtTemp.Rows[0]["JCLSH"].ToString();
                 model.YZZLZ = dtTemp.Rows[0]["YZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZLZ"].ToString();
                 model.YZYLZ = dtTemp.Rows[0]["YZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZYLZ"].ToString();
                 model.YZZZ = dtTemp.Rows[0]["YZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZZ"].ToString();
                 model.EZZLZ = dtTemp.Rows[0]["EZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZLZ"].ToString();
                 model.EZYLZ = dtTemp.Rows[0]["EZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZYLZ"].ToString();
                 model.EZZZ = dtTemp.Rows[0]["EZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZZ"].ToString();
                 model.SZZLZ = dtTemp.Rows[0]["SZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZZLZ"].ToString();
                 model.SZYLZ = dtTemp.Rows[0]["SZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZYLZ"].ToString();
                 model.SZZZ = dtTemp.Rows[0]["SZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZZZ"].ToString();
                 model.SIZZLZ = dtTemp.Rows[0]["SIZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZZLZ"].ToString();
                 model.SIZYLZ = dtTemp.Rows[0]["SIZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZYLZ"].ToString();
                 model.SIZZZ = dtTemp.Rows[0]["SIZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZZZ"].ToString();
                 model.WZZLZ = dtTemp.Rows[0]["WZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZZLZ"].ToString();
                 model.WZYLZ = dtTemp.Rows[0]["WZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZYLZ"].ToString();
                 model.WZZZ = dtTemp.Rows[0]["WZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZZZ"].ToString();
                 model.LZZLZ = dtTemp.Rows[0]["LZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZZLZ"].ToString();
                 model.LZYLZ = dtTemp.Rows[0]["LZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZYLZ"].ToString();
                 model.LZZZ = dtTemp.Rows[0]["LZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZZZ"].ToString();
                 model.YZZDTLH = dtTemp.Rows[0]["YZZDTLH"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZDTLH"].ToString();
                 model.YZYDTLH = dtTemp.Rows[0]["YZYDTLH"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZYDTLH"].ToString();
                 model.YZDTLH = dtTemp.Rows[0]["YZDTLH"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZDTLH"].ToString();
                 model.EZZDTLH = dtTemp.Rows[0]["EZZDTLH"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZDTLH"].ToString();
                 model.EZYDTLH = dtTemp.Rows[0]["EZYDTLH"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZYDTLH"].ToString();
                 model.EZDTLH = dtTemp.Rows[0]["EZDTLH"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZDTLH"].ToString();
                 model.ZCZLZ = dtTemp.Rows[0]["ZCZLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZCZLZ"].ToString();
                 model.ZCYLZ = dtTemp.Rows[0]["ZCYLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZCYLZ"].ToString();
                 model.ZCZZ = dtTemp.Rows[0]["ZCZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZCZZ"].ToString();
                 model.YZZZZL = dtTemp.Rows[0]["YZZZZL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZZZL"].ToString();
                 model.YZYZZL = dtTemp.Rows[0]["YZYZZL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZYZZL"].ToString();
                 model.YZZZZLV = dtTemp.Rows[0]["YZZZZLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZZZLV"].ToString();
                 model.YZYZZLV = dtTemp.Rows[0]["YZYZZLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZYZZLV"].ToString();
                 model.YZZZZL_PD = dtTemp.Rows[0]["YZZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZZZL_PD"].ToString();
                 model.YZYZZL_PD = dtTemp.Rows[0]["YZYZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZYZZL_PD"].ToString();
                 model.YZZZL_PD = dtTemp.Rows[0]["YZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZZL_PD"].ToString();
                 model.EZZZZL = dtTemp.Rows[0]["EZZZZL"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZZZL"].ToString();
                 model.EZYZZL = dtTemp.Rows[0]["EZYZZL"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZYZZL"].ToString();
                 model.EZZZZLV = dtTemp.Rows[0]["EZZZZLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZZZLV"].ToString();
                 model.EZYZZLV = dtTemp.Rows[0]["EZYZZLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZYZZLV"].ToString();
                 model.EZZZZL_PD = dtTemp.Rows[0]["EZZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZZZL_PD"].ToString();
                 model.EZYZZL_PD = dtTemp.Rows[0]["EZYZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZYZZL_PD"].ToString();
                 model.EZZZL_PD = dtTemp.Rows[0]["EZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZZL_PD"].ToString();
                 model.SZZZZL = dtTemp.Rows[0]["SZZZZL"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZZZZL"].ToString();
                 model.SZYZZL = dtTemp.Rows[0]["SZYZZL"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZYZZL"].ToString();
                 model.SZZZZLV = dtTemp.Rows[0]["SZZZZLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZZZZLV"].ToString();
                 model.SZYZZLV = dtTemp.Rows[0]["SZYZZLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZYZZLV"].ToString();
                 model.SZZZZL_PD = dtTemp.Rows[0]["SZZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZZZZL_PD"].ToString();
                 model.SZYZZL_PD = dtTemp.Rows[0]["SZYZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZYZZL_PD"].ToString();
                 model.SZZZL_PD = dtTemp.Rows[0]["SZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZZZL_PD"].ToString();
                 model.SIZZZZL = dtTemp.Rows[0]["SIZZZZL"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZZZZL"].ToString();
                 model.SIZYZZL = dtTemp.Rows[0]["SIZYZZL"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZYZZL"].ToString();
                 model.SIZZZZLV = dtTemp.Rows[0]["SIZZZZLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZZZZLV"].ToString();
                 model.SIZYZZLV = dtTemp.Rows[0]["SIZYZZLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZYZZLV"].ToString();
                 model.SIZZZZL_PD = dtTemp.Rows[0]["SIZZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZZZZL_PD"].ToString();
                 model.SIZYZZL_PD = dtTemp.Rows[0]["SIZYZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZYZZL_PD"].ToString();
                 model.SIZZZL_PD = dtTemp.Rows[0]["SIZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZZZL_PD"].ToString();
                 model.WZZZZL = dtTemp.Rows[0]["WZZZZL"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZZZZL"].ToString();
                 model.WZYZZL = dtTemp.Rows[0]["WZYZZL"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZYZZL"].ToString();
                 model.WZZZZLV = dtTemp.Rows[0]["WZZZZLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZZZZLV"].ToString();
                 model.WZYZZLV = dtTemp.Rows[0]["WZYZZLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZYZZLV"].ToString();
                 model.WZZZZL_PD = dtTemp.Rows[0]["WZZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZZZZL_PD"].ToString();
                 model.WZYZZL_PD = dtTemp.Rows[0]["WZYZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZYZZL_PD"].ToString();
                 model.WZZZL_PD = dtTemp.Rows[0]["WZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZZZL_PD"].ToString();
                 model.LZZZZL = dtTemp.Rows[0]["LZZZZL"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZZZZL"].ToString();
                 model.LZYZZL = dtTemp.Rows[0]["LZYZZL"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZYZZL"].ToString();
                 model.LZZZZLV = dtTemp.Rows[0]["LZZZZLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZZZZLV"].ToString();
                 model.LZYZZLV = dtTemp.Rows[0]["LZYZZLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZYZZLV"].ToString();
                 model.LZZZZL_PD = dtTemp.Rows[0]["LZZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZZZZL_PD"].ToString();
                 model.LZYZZL_PD = dtTemp.Rows[0]["LZYZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZYZZL_PD"].ToString();
                 model.LZZZL_PD = dtTemp.Rows[0]["LZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZZZL_PD"].ToString();
                 model.YZZZDCZD = dtTemp.Rows[0]["YZZZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZZDCZD"].ToString();
                 model.YZYZDCZD = dtTemp.Rows[0]["YZYZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZYZDCZD"].ToString();
                 model.YZBPHLV = dtTemp.Rows[0]["YZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZBPHLV"].ToString();
                 model.YZBPHLV_PD = dtTemp.Rows[0]["YZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZBPHLV_PD"].ToString();
                 model.EZZZDCZD = dtTemp.Rows[0]["EZZZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZZDCZD"].ToString();
                 model.EZYZDCZD = dtTemp.Rows[0]["EZYZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZYZDCZD"].ToString();
                 model.EZBPHLV = dtTemp.Rows[0]["EZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZBPHLV"].ToString();
                 model.EZBPHLV_PD = dtTemp.Rows[0]["EZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZBPHLV_PD"].ToString();
                 model.SZZZDCZD = dtTemp.Rows[0]["SZZZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZZZDCZD"].ToString();
                 model.SZYZDCZD = dtTemp.Rows[0]["SZYZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZYZDCZD"].ToString();
                 model.SZBPHLV = dtTemp.Rows[0]["SZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZBPHLV"].ToString();
                 model.SZBPHLV_PD = dtTemp.Rows[0]["SZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZBPHLV_PD"].ToString();
                 model.SIZZZDCZD = dtTemp.Rows[0]["SIZZZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZZZDCZD"].ToString();
                 model.SIZYZDCZD = dtTemp.Rows[0]["SIZYZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZYZDCZD"].ToString();
                 model.SIZBPHLV = dtTemp.Rows[0]["SIZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZBPHLV"].ToString();
                 model.SIZBPHLV_PD = dtTemp.Rows[0]["SIZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZBPHLV_PD"].ToString();
                 model.WZZZDCZD = dtTemp.Rows[0]["WZZZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZZZDCZD"].ToString();
                 model.WZYZDCZD = dtTemp.Rows[0]["WZYZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZYZDCZD"].ToString();
                 model.WZBPHLV = dtTemp.Rows[0]["WZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZBPHLV"].ToString();
                 model.WZBPHLV_PD = dtTemp.Rows[0]["WZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZBPHLV_PD"].ToString();
                 model.LZZZDCZD = dtTemp.Rows[0]["LZZZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZZZDCZD"].ToString();
                 model.LZYZDCZD = dtTemp.Rows[0]["LZYZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZYZDCZD"].ToString();
                 model.LZBPHLV = dtTemp.Rows[0]["LZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZBPHLV"].ToString();
                 model.LZBPHLV_PD = dtTemp.Rows[0]["LZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZBPHLV_PD"].ToString();
                 model.YZZZDZDL = dtTemp.Rows[0]["YZZZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZZDZDL"].ToString();
                 model.YZYZDZDL = dtTemp.Rows[0]["YZYZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZYZDZDL"].ToString();
                 model.YZZDLV = dtTemp.Rows[0]["YZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZDLV"].ToString();
                 model.YZZDLV_PD = dtTemp.Rows[0]["YZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZDLV_PD"].ToString();
                 model.EZZZDZDL = dtTemp.Rows[0]["EZZZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZZDZDL"].ToString();
                 model.EZYZDZDL = dtTemp.Rows[0]["EZYZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZYZDZDL"].ToString();
                 model.EZZDLV = dtTemp.Rows[0]["EZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZDLV"].ToString();
                 model.EZZDLV_PD = dtTemp.Rows[0]["EZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZDLV_PD"].ToString();
                 model.SZZZDZDL = dtTemp.Rows[0]["SZZZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZZZDZDL"].ToString();
                 model.SZYZDZDL = dtTemp.Rows[0]["SZYZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZYZDZDL"].ToString();
                 model.SZZDLV = dtTemp.Rows[0]["SZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZZDLV"].ToString();
                 model.SZZDLV_PD = dtTemp.Rows[0]["SZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZZDLV_PD"].ToString();
                 model.SIZZZDZDL = dtTemp.Rows[0]["SIZZZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZZZDZDL"].ToString();
                 model.SIZYZDZDL = dtTemp.Rows[0]["SIZYZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZYZDZDL"].ToString();
                 model.SIZZDLV = dtTemp.Rows[0]["SIZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZZDLV"].ToString();
                 model.SIZZDLV_PD = dtTemp.Rows[0]["SIZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZZDLV_PD"].ToString();
                 model.WZZZDZDL = dtTemp.Rows[0]["WZZZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZZZDZDL"].ToString();
                 model.WZYZDZDL = dtTemp.Rows[0]["WZYZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZYZDZDL"].ToString();
                 model.WZZDLV = dtTemp.Rows[0]["WZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZZDLV"].ToString();
                 model.WZZDLV_PD = dtTemp.Rows[0]["WZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZZDLV_PD"].ToString();
                 model.LZZZDZDL = dtTemp.Rows[0]["LZZZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZZZDZDL"].ToString();
                 model.LZYZDZDL = dtTemp.Rows[0]["LZYZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZYZDZDL"].ToString();
                 model.LZZDLV = dtTemp.Rows[0]["LZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZZDLV"].ToString();
                 model.LZZDLV_PD = dtTemp.Rows[0]["LZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZZDLV_PD"].ToString();
                 model.YZZSZDL = dtTemp.Rows[0]["YZZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZSZDL"].ToString();
                 model.YZYSZDL = dtTemp.Rows[0]["YZYSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZYSZDL"].ToString();
                 model.YZSZDL = dtTemp.Rows[0]["YZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZSZDL"].ToString();
                 model.EZZSZDL = dtTemp.Rows[0]["EZZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZSZDL"].ToString();
                 model.EZYSZDL = dtTemp.Rows[0]["EZYSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZYSZDL"].ToString();
                 model.EZSZDL = dtTemp.Rows[0]["EZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZSZDL"].ToString();
                 model.SZZSZDL = dtTemp.Rows[0]["SZZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZZSZDL"].ToString();
                 model.SZYSZDL = dtTemp.Rows[0]["SZYSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZYSZDL"].ToString();
                 model.SZSZDL = dtTemp.Rows[0]["SZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZSZDL"].ToString();
                 model.SIZZSZDL = dtTemp.Rows[0]["SIZZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZZSZDL"].ToString();
                 model.SIZYSZDL = dtTemp.Rows[0]["SIZYSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZYSZDL"].ToString();
                 model.SIZSZDL = dtTemp.Rows[0]["SIZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZSZDL"].ToString();
                 model.WZZSZDL = dtTemp.Rows[0]["WZZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZZSZDL"].ToString();
                 model.WZYSZDL = dtTemp.Rows[0]["WZYSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZYSZDL"].ToString();
                 model.WZSZDL = dtTemp.Rows[0]["WZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZSZDL"].ToString();
                 model.LZZSZDL = dtTemp.Rows[0]["LZZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZZSZDL"].ToString();
                 model.LZYSZDL = dtTemp.Rows[0]["LZYSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZYSZDL"].ToString();
                 model.LZSZDL = dtTemp.Rows[0]["LZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZSZDL"].ToString();
                 model.ZZSZDL = dtTemp.Rows[0]["ZZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZZSZDL"].ToString();
                 model.ZYSZDL = dtTemp.Rows[0]["ZYSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZYSZDL"].ToString();
                 model.ZSZDL = dtTemp.Rows[0]["ZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZSZDL"].ToString();
                 model.ZCSZDLV = dtTemp.Rows[0]["ZCSZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZCSZDLV"].ToString();
                 model.SZDLV_PD = dtTemp.Rows[0]["SZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZDLV_PD"].ToString();
                 model.ZCZDL = dtTemp.Rows[0]["ZCZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZCZDL"].ToString();
                 model.ZCZDLV = dtTemp.Rows[0]["ZCZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZCZDLV"].ToString();
                 model.ZCZDLV_PD = dtTemp.Rows[0]["ZCZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZCZDLV_PD"].ToString();
                 model.YZJZZZ = dtTemp.Rows[0]["YZJZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZJZZZ"].ToString();
                 model.EZJZZZ = dtTemp.Rows[0]["EZJZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZJZZZ"].ToString();
                 model.SZJZZZ = dtTemp.Rows[0]["SZJZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZJZZZ"].ToString();
                 model.SIZJZZZ = dtTemp.Rows[0]["SIZJZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZJZZZ"].ToString();
                 model.WZJZZZ = dtTemp.Rows[0]["WZJZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZJZZZ"].ToString();
                 model.LZJZZZ = dtTemp.Rows[0]["LZJZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZJZZZ"].ToString();
                 model.YZJZZDLV = dtTemp.Rows[0]["YZJZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZJZZDLV"].ToString();
                 model.YZJZZDLV_PD = dtTemp.Rows[0]["YZJZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZJZZDLV_PD"].ToString();
                 model.EZJZZDLV = dtTemp.Rows[0]["EZJZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZJZZDLV"].ToString();
                 model.EZJZZDLV_PD = dtTemp.Rows[0]["EZJZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZJZZDLV_PD"].ToString();
                 model.SZJZZDLV = dtTemp.Rows[0]["SZJZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZJZZDLV"].ToString();
                 model.SZJZZDLV_PD = dtTemp.Rows[0]["SZJZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZJZZDLV_PD"].ToString();
                 model.SIZJZZDLV = dtTemp.Rows[0]["SIZJZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZJZZDLV"].ToString();
                 model.SIZJZZDLV_PD = dtTemp.Rows[0]["SIZJZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZJZZDLV_PD"].ToString();
                 model.WZJZZDLV = dtTemp.Rows[0]["WZJZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZJZZDLV"].ToString();
                 model.WZJZZDLV_PD = dtTemp.Rows[0]["WZJZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZJZZDLV_PD"].ToString();
                 model.LZJZZDLV = dtTemp.Rows[0]["LZJZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZJZZDLV"].ToString();
                 model.LZJZZDLV_PD = dtTemp.Rows[0]["LZJZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZJZZDLV_PD"].ToString();
                 model.YZJZBPHLV = dtTemp.Rows[0]["YZJZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZJZBPHLV"].ToString();
                 model.YZJZBPHLV_PD = dtTemp.Rows[0]["YZJZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZJZBPHLV_PD"].ToString();
                 model.EZJZBPHLV = dtTemp.Rows[0]["EZJZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZJZBPHLV"].ToString();
                 model.EZJZBPHLV_PD = dtTemp.Rows[0]["EZJZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZJZBPHLV_PD"].ToString();
                 model.SZJZBPHLV = dtTemp.Rows[0]["SZJZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZJZBPHLV"].ToString();
                 model.SZJZBPHLV_PD = dtTemp.Rows[0]["SZJZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZJZBPHLV_PD"].ToString();
                 model.SIZJZBPHLV = dtTemp.Rows[0]["SIZJZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZJZBPHLV"].ToString();
                 model.SIZJZBPHLV_PD = dtTemp.Rows[0]["SIZJZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZJZBPHLV_PD"].ToString();
                 model.WZJZBPHLV = dtTemp.Rows[0]["WZJZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZJZBPHLV"].ToString();
                 model.WZJZBPHLV_PD = dtTemp.Rows[0]["WZJZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZJZBPHLV_PD"].ToString();
                 model.LZJZBPHLV = dtTemp.Rows[0]["LZJZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZJZBPHLV"].ToString();
                 model.LZJZBPHLV_PD = dtTemp.Rows[0]["LZJZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZJZBPHLV_PD"].ToString();
                 model.YZZDZ_PD = dtTemp.Rows[0]["YZZDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZDZ_PD"].ToString();
                 model.EZZDZ_PD = dtTemp.Rows[0]["EZZDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZDZ_PD"].ToString();
                 model.SZZDZ_PD = dtTemp.Rows[0]["SZZDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZZDZ_PD"].ToString();
                 model.SIZZDZ_PD = dtTemp.Rows[0]["SIZZDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZZDZ_PD"].ToString();
                 model.WZZDZ_PD = dtTemp.Rows[0]["WZZDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZZDZ_PD"].ToString();
                 model.LZZDZ_PD = dtTemp.Rows[0]["LZZDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZZDZ_PD"].ToString();
                 model.YZZZLVXZBZ = dtTemp.Rows[0]["YZZZLVXZBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZZLVXZBZ"].ToString();
                 model.EZZZLVXZBZ = dtTemp.Rows[0]["EZZZLVXZBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZZLVXZBZ"].ToString();
                 model.SZZZLVXZBZ = dtTemp.Rows[0]["SZZZLVXZBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZZZLVXZBZ"].ToString();
                 model.SIZZZLVXZBZ = dtTemp.Rows[0]["SIZZZLVXZBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZZZLVXZBZ"].ToString();
                 model.WZZZLVXZBZ = dtTemp.Rows[0]["WZZZLVXZBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZZZLVXZBZ"].ToString();
                 model.LZZZLVXZBZ = dtTemp.Rows[0]["LZZZLVXZBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZZZLVXZBZ"].ToString();
                 model.YZBPHLVBZ = dtTemp.Rows[0]["YZBPHLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZBPHLVBZ"].ToString();
                 model.EZBPHLVBZ = dtTemp.Rows[0]["EZBPHLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZBPHLVBZ"].ToString();
                 model.SZBPHLVBZ = dtTemp.Rows[0]["SZBPHLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZBPHLVBZ"].ToString();
                 model.SIZBPHLVBZ = dtTemp.Rows[0]["SIZBPHLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZBPHLVBZ"].ToString();
                 model.WZBPHLVBZ = dtTemp.Rows[0]["WZBPHLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZBPHLVBZ"].ToString();
                 model.LZBPHLVBZ = dtTemp.Rows[0]["LZBPHLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZBPHLVBZ"].ToString();
                 model.YZZDLVBZ = dtTemp.Rows[0]["YZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZZDLVBZ"].ToString();
                 model.EZZDLVBZ = dtTemp.Rows[0]["EZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZZDLVBZ"].ToString();
                 model.SZZDLVBZ = dtTemp.Rows[0]["SZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZZDLVBZ"].ToString();
                 model.SIZZDLVBZ = dtTemp.Rows[0]["SIZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZZDLVBZ"].ToString();
                 model.WZZDLVBZ = dtTemp.Rows[0]["WZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZZDLVBZ"].ToString();
                 model.LZZDLVBZ = dtTemp.Rows[0]["LZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZZDLVBZ"].ToString();
                 model.SZDLVBZ = dtTemp.Rows[0]["SZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZDLVBZ"].ToString();
                 model.ZCZDLVBZ = dtTemp.Rows[0]["ZCZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZCZDLVBZ"].ToString();
                 model.QCLCZCBZ = dtTemp.Rows[0]["QCLCZCBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["QCLCZCBZ"].ToString();
                 model.QCLCZC_PD = dtTemp.Rows[0]["QCLCZC_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["QCLCZC_PD"].ToString();
                 model.QCLCZCZDLV = dtTemp.Rows[0]["QCLCZCZDLV"] == DBNull.Value ? "" : dtTemp.Rows[0]["QCLCZCZDLV"].ToString();
                 model.ZZCZDL = dtTemp.Rows[0]["ZZCZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZZCZDL"].ToString();
                 model.YZCZDL = dtTemp.Rows[0]["YZCZDL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZCZDL"].ToString();
                 model.QZBPHLVBZ = dtTemp.Rows[0]["QZBPHLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["QZBPHLVBZ"].ToString();
                 model.HZBPHLVBZDY60 = dtTemp.Rows[0]["HZBPHLVBZDY60"] == DBNull.Value ? "" : dtTemp.Rows[0]["HZBPHLVBZDY60"].ToString();
                 model.HZBPHLVBZXY60 = dtTemp.Rows[0]["HZBPHLVBZXY60"] == DBNull.Value ? "" : dtTemp.Rows[0]["HZBPHLVBZXY60"].ToString();
                 model.FHTYZZZ = dtTemp.Rows[0]["FHTYZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTYZZZ"].ToString();
                 model.FHTYZZLZ = dtTemp.Rows[0]["FHTYZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTYZZLZ"].ToString();
                 model.FHTYZYLZ = dtTemp.Rows[0]["FHTYZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTYZYLZ"].ToString();
                 model.FHTEZZZ = dtTemp.Rows[0]["FHTEZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTEZZZ"].ToString();
                 model.FHTEZZLZ = dtTemp.Rows[0]["FHTEZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTEZZLZ"].ToString();
                 model.FHTEZYLZ = dtTemp.Rows[0]["FHTEZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTEZYLZ"].ToString();
                 model.FHTSZZZ = dtTemp.Rows[0]["FHTSZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTSZZZ"].ToString();
                 model.FHTSZZLZ = dtTemp.Rows[0]["FHTSZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTSZZLZ"].ToString();
                 model.FHTSZYLZ = dtTemp.Rows[0]["FHTSZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTSZYLZ"].ToString();
                 model.FHTSIZZZ = dtTemp.Rows[0]["FHTSIZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTSIZZZ"].ToString();
                 model.FHTSIZZLZ = dtTemp.Rows[0]["FHTSIZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTSIZZLZ"].ToString();
                 model.FHTSIZYLZ = dtTemp.Rows[0]["FHTSIZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTSIZYLZ"].ToString();
                 model.FHTWZZZ = dtTemp.Rows[0]["FHTWZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTWZZZ"].ToString();
                 model.FHTWZZLZ = dtTemp.Rows[0]["FHTWZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTWZZLZ"].ToString();
                 model.FHTWZYLZ = dtTemp.Rows[0]["FHTWZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTWZYLZ"].ToString();
                 model.FHTLZZZ = dtTemp.Rows[0]["FHTLZZZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTLZZZ"].ToString();
                 model.FHTLZZLZ = dtTemp.Rows[0]["FHTLZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTLZZLZ"].ToString();
                 model.FHTLZYLZ = dtTemp.Rows[0]["FHTLZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["FHTLZYLZ"].ToString();
                 model.YZJZZDLVBZ = dtTemp.Rows[0]["YZJZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YZJZZDLVBZ"].ToString();
                 model.EZJZZDLVBZ = dtTemp.Rows[0]["EZJZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["EZJZZDLVBZ"].ToString();
                 model.SZJZZDLVBZ = dtTemp.Rows[0]["SZJZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SZJZZDLVBZ"].ToString();
                 model.SIZJZZDLVBZ = dtTemp.Rows[0]["SIZJZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["SIZJZZDLVBZ"].ToString();
                 model.WZJZZDLVBZ = dtTemp.Rows[0]["WZJZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["WZJZZDLVBZ"].ToString();
                 model.LZJZZDLVBZ = dtTemp.Rows[0]["LZJZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["LZJZZDLVBZ"].ToString();
             }

             dtTemp.Dispose();

             return model;
         }

         /// <summary>
         /// 得到一个对象实体
         /// </summary>
         public void GetModel(ref DataTable p_dtData, string strJCLSH)
         {
             p_dtData.Clear();

             string strSql = "";
             strSql += "select * from RESULT_BRAKE";
             strSql += " where ";
               strSql += " JCLSH='"+ strJCLSH +"'";

              DbHelper.GetTable(strSql, ref p_dtData);
         }

      /// <summary>
      /// 得到对象集合
      /// </summary>
      public RESULT_BRAKE[] GetModelList(string p_strWhere, string p_strOrder, int p_intPageNumber, int p_intPageSize)
      {
          int m_intPageNumber = p_intPageNumber;
          int m_intPageCount = GetPageCount(p_strWhere, p_intPageSize);

          if((m_intPageNumber < 1) || (m_intPageNumber == 0))
          {
               m_intPageNumber = 1;
          }

          if(m_intPageNumber == -1)
          {
               m_intPageNumber = m_intPageCount;
          }

          if(m_intPageNumber > m_intPageCount)
          {
               m_intPageNumber = m_intPageCount;
          }

          string strSql = "";
          strSql += "select * from RESULT_BRAKE";
          if(p_strWhere.Trim().Length > 0)
          {
               strSql += " where " + p_strWhere;
          }
          if(p_strOrder.Trim().Length > 0)
          {
               strSql += " order by " + p_strOrder;
          }

          DataTable dtTemp = new DataTable();

          if(p_intPageSize > 0)
          {
               DbHelper.GetTable(strSql, ref dtTemp, (m_intPageNumber-1)*p_intPageSize, p_intPageSize);
          }
          else
          {
               DbHelper.GetTable(strSql, ref dtTemp);
          }

          RESULT_BRAKE[] arrModel=new RESULT_BRAKE[dtTemp.Rows.Count];

          for(int N=0;N<dtTemp.Rows.Count;N++)
          {
               arrModel[N] = new RESULT_BRAKE();

                 arrModel[N].ID = dtTemp.Rows[N]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[N]["ID"]);
                 arrModel[N].ZDYZJCCS = dtTemp.Rows[N]["ZDYZJCCS"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZDYZJCCS"].ToString();
                 arrModel[N].ZDEZJCCS = dtTemp.Rows[N]["ZDEZJCCS"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZDEZJCCS"].ToString();
                 arrModel[N].ZDSZJCCS = dtTemp.Rows[N]["ZDSZJCCS"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZDSZJCCS"].ToString();
                 arrModel[N].ZDSIZJCCS = dtTemp.Rows[N]["ZDSIZJCCS"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZDSIZJCCS"].ToString();
                 arrModel[N].ZDWZJCCS = dtTemp.Rows[N]["ZDWZJCCS"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZDWZJCCS"].ToString();
                 arrModel[N].ZDLZJCCS = dtTemp.Rows[N]["ZDLZJCCS"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZDLZJCCS"].ToString();
                 arrModel[N].ZDSZDJCCS = dtTemp.Rows[N]["ZDSZDJCCS"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZDSZDJCCS"].ToString();
                 arrModel[N].ZDZCJCCS = dtTemp.Rows[N]["ZDZCJCCS"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZDZCJCCS"].ToString();
                 arrModel[N].JCLSH = dtTemp.Rows[N]["JCLSH"] == DBNull.Value ? "" : dtTemp.Rows[N]["JCLSH"].ToString();
                 arrModel[N].YZZLZ = dtTemp.Rows[N]["YZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZLZ"].ToString();
                 arrModel[N].YZYLZ = dtTemp.Rows[N]["YZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZYLZ"].ToString();
                 arrModel[N].YZZZ = dtTemp.Rows[N]["YZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZZ"].ToString();
                 arrModel[N].EZZLZ = dtTemp.Rows[N]["EZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZLZ"].ToString();
                 arrModel[N].EZYLZ = dtTemp.Rows[N]["EZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZYLZ"].ToString();
                 arrModel[N].EZZZ = dtTemp.Rows[N]["EZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZZ"].ToString();
                 arrModel[N].SZZLZ = dtTemp.Rows[N]["SZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZZLZ"].ToString();
                 arrModel[N].SZYLZ = dtTemp.Rows[N]["SZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZYLZ"].ToString();
                 arrModel[N].SZZZ = dtTemp.Rows[N]["SZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZZZ"].ToString();
                 arrModel[N].SIZZLZ = dtTemp.Rows[N]["SIZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZZLZ"].ToString();
                 arrModel[N].SIZYLZ = dtTemp.Rows[N]["SIZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZYLZ"].ToString();
                 arrModel[N].SIZZZ = dtTemp.Rows[N]["SIZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZZZ"].ToString();
                 arrModel[N].WZZLZ = dtTemp.Rows[N]["WZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZZLZ"].ToString();
                 arrModel[N].WZYLZ = dtTemp.Rows[N]["WZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZYLZ"].ToString();
                 arrModel[N].WZZZ = dtTemp.Rows[N]["WZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZZZ"].ToString();
                 arrModel[N].LZZLZ = dtTemp.Rows[N]["LZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZZLZ"].ToString();
                 arrModel[N].LZYLZ = dtTemp.Rows[N]["LZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZYLZ"].ToString();
                 arrModel[N].LZZZ = dtTemp.Rows[N]["LZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZZZ"].ToString();
                 arrModel[N].YZZDTLH = dtTemp.Rows[N]["YZZDTLH"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZDTLH"].ToString();
                 arrModel[N].YZYDTLH = dtTemp.Rows[N]["YZYDTLH"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZYDTLH"].ToString();
                 arrModel[N].YZDTLH = dtTemp.Rows[N]["YZDTLH"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZDTLH"].ToString();
                 arrModel[N].EZZDTLH = dtTemp.Rows[N]["EZZDTLH"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZDTLH"].ToString();
                 arrModel[N].EZYDTLH = dtTemp.Rows[N]["EZYDTLH"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZYDTLH"].ToString();
                 arrModel[N].EZDTLH = dtTemp.Rows[N]["EZDTLH"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZDTLH"].ToString();
                 arrModel[N].ZCZLZ = dtTemp.Rows[N]["ZCZLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZCZLZ"].ToString();
                 arrModel[N].ZCYLZ = dtTemp.Rows[N]["ZCYLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZCYLZ"].ToString();
                 arrModel[N].ZCZZ = dtTemp.Rows[N]["ZCZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZCZZ"].ToString();
                 arrModel[N].YZZZZL = dtTemp.Rows[N]["YZZZZL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZZZL"].ToString();
                 arrModel[N].YZYZZL = dtTemp.Rows[N]["YZYZZL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZYZZL"].ToString();
                 arrModel[N].YZZZZLV = dtTemp.Rows[N]["YZZZZLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZZZLV"].ToString();
                 arrModel[N].YZYZZLV = dtTemp.Rows[N]["YZYZZLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZYZZLV"].ToString();
                 arrModel[N].YZZZZL_PD = dtTemp.Rows[N]["YZZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZZZL_PD"].ToString();
                 arrModel[N].YZYZZL_PD = dtTemp.Rows[N]["YZYZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZYZZL_PD"].ToString();
                 arrModel[N].YZZZL_PD = dtTemp.Rows[N]["YZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZZL_PD"].ToString();
                 arrModel[N].EZZZZL = dtTemp.Rows[N]["EZZZZL"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZZZL"].ToString();
                 arrModel[N].EZYZZL = dtTemp.Rows[N]["EZYZZL"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZYZZL"].ToString();
                 arrModel[N].EZZZZLV = dtTemp.Rows[N]["EZZZZLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZZZLV"].ToString();
                 arrModel[N].EZYZZLV = dtTemp.Rows[N]["EZYZZLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZYZZLV"].ToString();
                 arrModel[N].EZZZZL_PD = dtTemp.Rows[N]["EZZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZZZL_PD"].ToString();
                 arrModel[N].EZYZZL_PD = dtTemp.Rows[N]["EZYZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZYZZL_PD"].ToString();
                 arrModel[N].EZZZL_PD = dtTemp.Rows[N]["EZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZZL_PD"].ToString();
                 arrModel[N].SZZZZL = dtTemp.Rows[N]["SZZZZL"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZZZZL"].ToString();
                 arrModel[N].SZYZZL = dtTemp.Rows[N]["SZYZZL"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZYZZL"].ToString();
                 arrModel[N].SZZZZLV = dtTemp.Rows[N]["SZZZZLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZZZZLV"].ToString();
                 arrModel[N].SZYZZLV = dtTemp.Rows[N]["SZYZZLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZYZZLV"].ToString();
                 arrModel[N].SZZZZL_PD = dtTemp.Rows[N]["SZZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZZZZL_PD"].ToString();
                 arrModel[N].SZYZZL_PD = dtTemp.Rows[N]["SZYZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZYZZL_PD"].ToString();
                 arrModel[N].SZZZL_PD = dtTemp.Rows[N]["SZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZZZL_PD"].ToString();
                 arrModel[N].SIZZZZL = dtTemp.Rows[N]["SIZZZZL"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZZZZL"].ToString();
                 arrModel[N].SIZYZZL = dtTemp.Rows[N]["SIZYZZL"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZYZZL"].ToString();
                 arrModel[N].SIZZZZLV = dtTemp.Rows[N]["SIZZZZLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZZZZLV"].ToString();
                 arrModel[N].SIZYZZLV = dtTemp.Rows[N]["SIZYZZLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZYZZLV"].ToString();
                 arrModel[N].SIZZZZL_PD = dtTemp.Rows[N]["SIZZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZZZZL_PD"].ToString();
                 arrModel[N].SIZYZZL_PD = dtTemp.Rows[N]["SIZYZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZYZZL_PD"].ToString();
                 arrModel[N].SIZZZL_PD = dtTemp.Rows[N]["SIZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZZZL_PD"].ToString();
                 arrModel[N].WZZZZL = dtTemp.Rows[N]["WZZZZL"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZZZZL"].ToString();
                 arrModel[N].WZYZZL = dtTemp.Rows[N]["WZYZZL"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZYZZL"].ToString();
                 arrModel[N].WZZZZLV = dtTemp.Rows[N]["WZZZZLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZZZZLV"].ToString();
                 arrModel[N].WZYZZLV = dtTemp.Rows[N]["WZYZZLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZYZZLV"].ToString();
                 arrModel[N].WZZZZL_PD = dtTemp.Rows[N]["WZZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZZZZL_PD"].ToString();
                 arrModel[N].WZYZZL_PD = dtTemp.Rows[N]["WZYZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZYZZL_PD"].ToString();
                 arrModel[N].WZZZL_PD = dtTemp.Rows[N]["WZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZZZL_PD"].ToString();
                 arrModel[N].LZZZZL = dtTemp.Rows[N]["LZZZZL"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZZZZL"].ToString();
                 arrModel[N].LZYZZL = dtTemp.Rows[N]["LZYZZL"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZYZZL"].ToString();
                 arrModel[N].LZZZZLV = dtTemp.Rows[N]["LZZZZLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZZZZLV"].ToString();
                 arrModel[N].LZYZZLV = dtTemp.Rows[N]["LZYZZLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZYZZLV"].ToString();
                 arrModel[N].LZZZZL_PD = dtTemp.Rows[N]["LZZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZZZZL_PD"].ToString();
                 arrModel[N].LZYZZL_PD = dtTemp.Rows[N]["LZYZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZYZZL_PD"].ToString();
                 arrModel[N].LZZZL_PD = dtTemp.Rows[N]["LZZZL_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZZZL_PD"].ToString();
                 arrModel[N].YZZZDCZD = dtTemp.Rows[N]["YZZZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZZDCZD"].ToString();
                 arrModel[N].YZYZDCZD = dtTemp.Rows[N]["YZYZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZYZDCZD"].ToString();
                 arrModel[N].YZBPHLV = dtTemp.Rows[N]["YZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZBPHLV"].ToString();
                 arrModel[N].YZBPHLV_PD = dtTemp.Rows[N]["YZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZBPHLV_PD"].ToString();
                 arrModel[N].EZZZDCZD = dtTemp.Rows[N]["EZZZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZZDCZD"].ToString();
                 arrModel[N].EZYZDCZD = dtTemp.Rows[N]["EZYZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZYZDCZD"].ToString();
                 arrModel[N].EZBPHLV = dtTemp.Rows[N]["EZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZBPHLV"].ToString();
                 arrModel[N].EZBPHLV_PD = dtTemp.Rows[N]["EZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZBPHLV_PD"].ToString();
                 arrModel[N].SZZZDCZD = dtTemp.Rows[N]["SZZZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZZZDCZD"].ToString();
                 arrModel[N].SZYZDCZD = dtTemp.Rows[N]["SZYZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZYZDCZD"].ToString();
                 arrModel[N].SZBPHLV = dtTemp.Rows[N]["SZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZBPHLV"].ToString();
                 arrModel[N].SZBPHLV_PD = dtTemp.Rows[N]["SZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZBPHLV_PD"].ToString();
                 arrModel[N].SIZZZDCZD = dtTemp.Rows[N]["SIZZZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZZZDCZD"].ToString();
                 arrModel[N].SIZYZDCZD = dtTemp.Rows[N]["SIZYZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZYZDCZD"].ToString();
                 arrModel[N].SIZBPHLV = dtTemp.Rows[N]["SIZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZBPHLV"].ToString();
                 arrModel[N].SIZBPHLV_PD = dtTemp.Rows[N]["SIZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZBPHLV_PD"].ToString();
                 arrModel[N].WZZZDCZD = dtTemp.Rows[N]["WZZZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZZZDCZD"].ToString();
                 arrModel[N].WZYZDCZD = dtTemp.Rows[N]["WZYZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZYZDCZD"].ToString();
                 arrModel[N].WZBPHLV = dtTemp.Rows[N]["WZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZBPHLV"].ToString();
                 arrModel[N].WZBPHLV_PD = dtTemp.Rows[N]["WZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZBPHLV_PD"].ToString();
                 arrModel[N].LZZZDCZD = dtTemp.Rows[N]["LZZZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZZZDCZD"].ToString();
                 arrModel[N].LZYZDCZD = dtTemp.Rows[N]["LZYZDCZD"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZYZDCZD"].ToString();
                 arrModel[N].LZBPHLV = dtTemp.Rows[N]["LZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZBPHLV"].ToString();
                 arrModel[N].LZBPHLV_PD = dtTemp.Rows[N]["LZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZBPHLV_PD"].ToString();
                 arrModel[N].YZZZDZDL = dtTemp.Rows[N]["YZZZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZZDZDL"].ToString();
                 arrModel[N].YZYZDZDL = dtTemp.Rows[N]["YZYZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZYZDZDL"].ToString();
                 arrModel[N].YZZDLV = dtTemp.Rows[N]["YZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZDLV"].ToString();
                 arrModel[N].YZZDLV_PD = dtTemp.Rows[N]["YZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZDLV_PD"].ToString();
                 arrModel[N].EZZZDZDL = dtTemp.Rows[N]["EZZZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZZDZDL"].ToString();
                 arrModel[N].EZYZDZDL = dtTemp.Rows[N]["EZYZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZYZDZDL"].ToString();
                 arrModel[N].EZZDLV = dtTemp.Rows[N]["EZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZDLV"].ToString();
                 arrModel[N].EZZDLV_PD = dtTemp.Rows[N]["EZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZDLV_PD"].ToString();
                 arrModel[N].SZZZDZDL = dtTemp.Rows[N]["SZZZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZZZDZDL"].ToString();
                 arrModel[N].SZYZDZDL = dtTemp.Rows[N]["SZYZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZYZDZDL"].ToString();
                 arrModel[N].SZZDLV = dtTemp.Rows[N]["SZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZZDLV"].ToString();
                 arrModel[N].SZZDLV_PD = dtTemp.Rows[N]["SZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZZDLV_PD"].ToString();
                 arrModel[N].SIZZZDZDL = dtTemp.Rows[N]["SIZZZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZZZDZDL"].ToString();
                 arrModel[N].SIZYZDZDL = dtTemp.Rows[N]["SIZYZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZYZDZDL"].ToString();
                 arrModel[N].SIZZDLV = dtTemp.Rows[N]["SIZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZZDLV"].ToString();
                 arrModel[N].SIZZDLV_PD = dtTemp.Rows[N]["SIZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZZDLV_PD"].ToString();
                 arrModel[N].WZZZDZDL = dtTemp.Rows[N]["WZZZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZZZDZDL"].ToString();
                 arrModel[N].WZYZDZDL = dtTemp.Rows[N]["WZYZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZYZDZDL"].ToString();
                 arrModel[N].WZZDLV = dtTemp.Rows[N]["WZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZZDLV"].ToString();
                 arrModel[N].WZZDLV_PD = dtTemp.Rows[N]["WZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZZDLV_PD"].ToString();
                 arrModel[N].LZZZDZDL = dtTemp.Rows[N]["LZZZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZZZDZDL"].ToString();
                 arrModel[N].LZYZDZDL = dtTemp.Rows[N]["LZYZDZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZYZDZDL"].ToString();
                 arrModel[N].LZZDLV = dtTemp.Rows[N]["LZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZZDLV"].ToString();
                 arrModel[N].LZZDLV_PD = dtTemp.Rows[N]["LZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZZDLV_PD"].ToString();
                 arrModel[N].YZZSZDL = dtTemp.Rows[N]["YZZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZSZDL"].ToString();
                 arrModel[N].YZYSZDL = dtTemp.Rows[N]["YZYSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZYSZDL"].ToString();
                 arrModel[N].YZSZDL = dtTemp.Rows[N]["YZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZSZDL"].ToString();
                 arrModel[N].EZZSZDL = dtTemp.Rows[N]["EZZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZSZDL"].ToString();
                 arrModel[N].EZYSZDL = dtTemp.Rows[N]["EZYSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZYSZDL"].ToString();
                 arrModel[N].EZSZDL = dtTemp.Rows[N]["EZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZSZDL"].ToString();
                 arrModel[N].SZZSZDL = dtTemp.Rows[N]["SZZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZZSZDL"].ToString();
                 arrModel[N].SZYSZDL = dtTemp.Rows[N]["SZYSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZYSZDL"].ToString();
                 arrModel[N].SZSZDL = dtTemp.Rows[N]["SZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZSZDL"].ToString();
                 arrModel[N].SIZZSZDL = dtTemp.Rows[N]["SIZZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZZSZDL"].ToString();
                 arrModel[N].SIZYSZDL = dtTemp.Rows[N]["SIZYSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZYSZDL"].ToString();
                 arrModel[N].SIZSZDL = dtTemp.Rows[N]["SIZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZSZDL"].ToString();
                 arrModel[N].WZZSZDL = dtTemp.Rows[N]["WZZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZZSZDL"].ToString();
                 arrModel[N].WZYSZDL = dtTemp.Rows[N]["WZYSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZYSZDL"].ToString();
                 arrModel[N].WZSZDL = dtTemp.Rows[N]["WZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZSZDL"].ToString();
                 arrModel[N].LZZSZDL = dtTemp.Rows[N]["LZZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZZSZDL"].ToString();
                 arrModel[N].LZYSZDL = dtTemp.Rows[N]["LZYSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZYSZDL"].ToString();
                 arrModel[N].LZSZDL = dtTemp.Rows[N]["LZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZSZDL"].ToString();
                 arrModel[N].ZZSZDL = dtTemp.Rows[N]["ZZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZZSZDL"].ToString();
                 arrModel[N].ZYSZDL = dtTemp.Rows[N]["ZYSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZYSZDL"].ToString();
                 arrModel[N].ZSZDL = dtTemp.Rows[N]["ZSZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZSZDL"].ToString();
                 arrModel[N].ZCSZDLV = dtTemp.Rows[N]["ZCSZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZCSZDLV"].ToString();
                 arrModel[N].SZDLV_PD = dtTemp.Rows[N]["SZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZDLV_PD"].ToString();
                 arrModel[N].ZCZDL = dtTemp.Rows[N]["ZCZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZCZDL"].ToString();
                 arrModel[N].ZCZDLV = dtTemp.Rows[N]["ZCZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZCZDLV"].ToString();
                 arrModel[N].ZCZDLV_PD = dtTemp.Rows[N]["ZCZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZCZDLV_PD"].ToString();
                 arrModel[N].YZJZZZ = dtTemp.Rows[N]["YZJZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZJZZZ"].ToString();
                 arrModel[N].EZJZZZ = dtTemp.Rows[N]["EZJZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZJZZZ"].ToString();
                 arrModel[N].SZJZZZ = dtTemp.Rows[N]["SZJZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZJZZZ"].ToString();
                 arrModel[N].SIZJZZZ = dtTemp.Rows[N]["SIZJZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZJZZZ"].ToString();
                 arrModel[N].WZJZZZ = dtTemp.Rows[N]["WZJZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZJZZZ"].ToString();
                 arrModel[N].LZJZZZ = dtTemp.Rows[N]["LZJZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZJZZZ"].ToString();
                 arrModel[N].YZJZZDLV = dtTemp.Rows[N]["YZJZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZJZZDLV"].ToString();
                 arrModel[N].YZJZZDLV_PD = dtTemp.Rows[N]["YZJZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZJZZDLV_PD"].ToString();
                 arrModel[N].EZJZZDLV = dtTemp.Rows[N]["EZJZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZJZZDLV"].ToString();
                 arrModel[N].EZJZZDLV_PD = dtTemp.Rows[N]["EZJZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZJZZDLV_PD"].ToString();
                 arrModel[N].SZJZZDLV = dtTemp.Rows[N]["SZJZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZJZZDLV"].ToString();
                 arrModel[N].SZJZZDLV_PD = dtTemp.Rows[N]["SZJZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZJZZDLV_PD"].ToString();
                 arrModel[N].SIZJZZDLV = dtTemp.Rows[N]["SIZJZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZJZZDLV"].ToString();
                 arrModel[N].SIZJZZDLV_PD = dtTemp.Rows[N]["SIZJZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZJZZDLV_PD"].ToString();
                 arrModel[N].WZJZZDLV = dtTemp.Rows[N]["WZJZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZJZZDLV"].ToString();
                 arrModel[N].WZJZZDLV_PD = dtTemp.Rows[N]["WZJZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZJZZDLV_PD"].ToString();
                 arrModel[N].LZJZZDLV = dtTemp.Rows[N]["LZJZZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZJZZDLV"].ToString();
                 arrModel[N].LZJZZDLV_PD = dtTemp.Rows[N]["LZJZZDLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZJZZDLV_PD"].ToString();
                 arrModel[N].YZJZBPHLV = dtTemp.Rows[N]["YZJZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZJZBPHLV"].ToString();
                 arrModel[N].YZJZBPHLV_PD = dtTemp.Rows[N]["YZJZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZJZBPHLV_PD"].ToString();
                 arrModel[N].EZJZBPHLV = dtTemp.Rows[N]["EZJZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZJZBPHLV"].ToString();
                 arrModel[N].EZJZBPHLV_PD = dtTemp.Rows[N]["EZJZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZJZBPHLV_PD"].ToString();
                 arrModel[N].SZJZBPHLV = dtTemp.Rows[N]["SZJZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZJZBPHLV"].ToString();
                 arrModel[N].SZJZBPHLV_PD = dtTemp.Rows[N]["SZJZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZJZBPHLV_PD"].ToString();
                 arrModel[N].SIZJZBPHLV = dtTemp.Rows[N]["SIZJZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZJZBPHLV"].ToString();
                 arrModel[N].SIZJZBPHLV_PD = dtTemp.Rows[N]["SIZJZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZJZBPHLV_PD"].ToString();
                 arrModel[N].WZJZBPHLV = dtTemp.Rows[N]["WZJZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZJZBPHLV"].ToString();
                 arrModel[N].WZJZBPHLV_PD = dtTemp.Rows[N]["WZJZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZJZBPHLV_PD"].ToString();
                 arrModel[N].LZJZBPHLV = dtTemp.Rows[N]["LZJZBPHLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZJZBPHLV"].ToString();
                 arrModel[N].LZJZBPHLV_PD = dtTemp.Rows[N]["LZJZBPHLV_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZJZBPHLV_PD"].ToString();
                 arrModel[N].YZZDZ_PD = dtTemp.Rows[N]["YZZDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZDZ_PD"].ToString();
                 arrModel[N].EZZDZ_PD = dtTemp.Rows[N]["EZZDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZDZ_PD"].ToString();
                 arrModel[N].SZZDZ_PD = dtTemp.Rows[N]["SZZDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZZDZ_PD"].ToString();
                 arrModel[N].SIZZDZ_PD = dtTemp.Rows[N]["SIZZDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZZDZ_PD"].ToString();
                 arrModel[N].WZZDZ_PD = dtTemp.Rows[N]["WZZDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZZDZ_PD"].ToString();
                 arrModel[N].LZZDZ_PD = dtTemp.Rows[N]["LZZDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZZDZ_PD"].ToString();
                 arrModel[N].YZZZLVXZBZ = dtTemp.Rows[N]["YZZZLVXZBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZZLVXZBZ"].ToString();
                 arrModel[N].EZZZLVXZBZ = dtTemp.Rows[N]["EZZZLVXZBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZZLVXZBZ"].ToString();
                 arrModel[N].SZZZLVXZBZ = dtTemp.Rows[N]["SZZZLVXZBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZZZLVXZBZ"].ToString();
                 arrModel[N].SIZZZLVXZBZ = dtTemp.Rows[N]["SIZZZLVXZBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZZZLVXZBZ"].ToString();
                 arrModel[N].WZZZLVXZBZ = dtTemp.Rows[N]["WZZZLVXZBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZZZLVXZBZ"].ToString();
                 arrModel[N].LZZZLVXZBZ = dtTemp.Rows[N]["LZZZLVXZBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZZZLVXZBZ"].ToString();
                 arrModel[N].YZBPHLVBZ = dtTemp.Rows[N]["YZBPHLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZBPHLVBZ"].ToString();
                 arrModel[N].EZBPHLVBZ = dtTemp.Rows[N]["EZBPHLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZBPHLVBZ"].ToString();
                 arrModel[N].SZBPHLVBZ = dtTemp.Rows[N]["SZBPHLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZBPHLVBZ"].ToString();
                 arrModel[N].SIZBPHLVBZ = dtTemp.Rows[N]["SIZBPHLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZBPHLVBZ"].ToString();
                 arrModel[N].WZBPHLVBZ = dtTemp.Rows[N]["WZBPHLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZBPHLVBZ"].ToString();
                 arrModel[N].LZBPHLVBZ = dtTemp.Rows[N]["LZBPHLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZBPHLVBZ"].ToString();
                 arrModel[N].YZZDLVBZ = dtTemp.Rows[N]["YZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZZDLVBZ"].ToString();
                 arrModel[N].EZZDLVBZ = dtTemp.Rows[N]["EZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZZDLVBZ"].ToString();
                 arrModel[N].SZZDLVBZ = dtTemp.Rows[N]["SZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZZDLVBZ"].ToString();
                 arrModel[N].SIZZDLVBZ = dtTemp.Rows[N]["SIZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZZDLVBZ"].ToString();
                 arrModel[N].WZZDLVBZ = dtTemp.Rows[N]["WZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZZDLVBZ"].ToString();
                 arrModel[N].LZZDLVBZ = dtTemp.Rows[N]["LZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZZDLVBZ"].ToString();
                 arrModel[N].SZDLVBZ = dtTemp.Rows[N]["SZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZDLVBZ"].ToString();
                 arrModel[N].ZCZDLVBZ = dtTemp.Rows[N]["ZCZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZCZDLVBZ"].ToString();
                 arrModel[N].QCLCZCBZ = dtTemp.Rows[N]["QCLCZCBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["QCLCZCBZ"].ToString();
                 arrModel[N].QCLCZC_PD = dtTemp.Rows[N]["QCLCZC_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["QCLCZC_PD"].ToString();
                 arrModel[N].QCLCZCZDLV = dtTemp.Rows[N]["QCLCZCZDLV"] == DBNull.Value ? "" : dtTemp.Rows[N]["QCLCZCZDLV"].ToString();
                 arrModel[N].ZZCZDL = dtTemp.Rows[N]["ZZCZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZZCZDL"].ToString();
                 arrModel[N].YZCZDL = dtTemp.Rows[N]["YZCZDL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZCZDL"].ToString();
                 arrModel[N].QZBPHLVBZ = dtTemp.Rows[N]["QZBPHLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["QZBPHLVBZ"].ToString();
                 arrModel[N].HZBPHLVBZDY60 = dtTemp.Rows[N]["HZBPHLVBZDY60"] == DBNull.Value ? "" : dtTemp.Rows[N]["HZBPHLVBZDY60"].ToString();
                 arrModel[N].HZBPHLVBZXY60 = dtTemp.Rows[N]["HZBPHLVBZXY60"] == DBNull.Value ? "" : dtTemp.Rows[N]["HZBPHLVBZXY60"].ToString();
                 arrModel[N].FHTYZZZ = dtTemp.Rows[N]["FHTYZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTYZZZ"].ToString();
                 arrModel[N].FHTYZZLZ = dtTemp.Rows[N]["FHTYZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTYZZLZ"].ToString();
                 arrModel[N].FHTYZYLZ = dtTemp.Rows[N]["FHTYZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTYZYLZ"].ToString();
                 arrModel[N].FHTEZZZ = dtTemp.Rows[N]["FHTEZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTEZZZ"].ToString();
                 arrModel[N].FHTEZZLZ = dtTemp.Rows[N]["FHTEZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTEZZLZ"].ToString();
                 arrModel[N].FHTEZYLZ = dtTemp.Rows[N]["FHTEZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTEZYLZ"].ToString();
                 arrModel[N].FHTSZZZ = dtTemp.Rows[N]["FHTSZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTSZZZ"].ToString();
                 arrModel[N].FHTSZZLZ = dtTemp.Rows[N]["FHTSZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTSZZLZ"].ToString();
                 arrModel[N].FHTSZYLZ = dtTemp.Rows[N]["FHTSZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTSZYLZ"].ToString();
                 arrModel[N].FHTSIZZZ = dtTemp.Rows[N]["FHTSIZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTSIZZZ"].ToString();
                 arrModel[N].FHTSIZZLZ = dtTemp.Rows[N]["FHTSIZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTSIZZLZ"].ToString();
                 arrModel[N].FHTSIZYLZ = dtTemp.Rows[N]["FHTSIZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTSIZYLZ"].ToString();
                 arrModel[N].FHTWZZZ = dtTemp.Rows[N]["FHTWZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTWZZZ"].ToString();
                 arrModel[N].FHTWZZLZ = dtTemp.Rows[N]["FHTWZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTWZZLZ"].ToString();
                 arrModel[N].FHTWZYLZ = dtTemp.Rows[N]["FHTWZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTWZYLZ"].ToString();
                 arrModel[N].FHTLZZZ = dtTemp.Rows[N]["FHTLZZZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTLZZZ"].ToString();
                 arrModel[N].FHTLZZLZ = dtTemp.Rows[N]["FHTLZZLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTLZZLZ"].ToString();
                 arrModel[N].FHTLZYLZ = dtTemp.Rows[N]["FHTLZYLZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["FHTLZYLZ"].ToString();
                 arrModel[N].YZJZZDLVBZ = dtTemp.Rows[N]["YZJZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YZJZZDLVBZ"].ToString();
                 arrModel[N].EZJZZDLVBZ = dtTemp.Rows[N]["EZJZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["EZJZZDLVBZ"].ToString();
                 arrModel[N].SZJZZDLVBZ = dtTemp.Rows[N]["SZJZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SZJZZDLVBZ"].ToString();
                 arrModel[N].SIZJZZDLVBZ = dtTemp.Rows[N]["SIZJZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["SIZJZZDLVBZ"].ToString();
                 arrModel[N].WZJZZDLVBZ = dtTemp.Rows[N]["WZJZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["WZJZZDLVBZ"].ToString();
                 arrModel[N].LZJZZDLVBZ = dtTemp.Rows[N]["LZJZZDLVBZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["LZJZZDLVBZ"].ToString();
          }

          dtTemp.Dispose();

          return arrModel;
      }

      /// <summary>
      /// 得到对象集合
      /// </summary>
      public RESULT_BRAKE[] GetModelList(string p_strWhere)
      {
          return GetModelList(p_strWhere, "", -1, -1);
      }

      /// <summary>
      /// 得到对象集合
      /// </summary>
      public RESULT_BRAKE[] GetModelList(string p_strWhere, string p_strOrder)
      {
          return GetModelList(p_strWhere, p_strOrder, -1, -1);
      }

      /// <summary>
      /// 得到对象集合
      /// </summary>
      public RESULT_BRAKE[] GetModelList(int p_intPageNumber, int p_intPageSize)
      {
          return GetModelList("", "", p_intPageNumber, p_intPageSize);
      }

      /// <summary>
      /// 得到对象集合
      /// </summary>
      public RESULT_BRAKE[] GetModelList(string p_strWhere, int p_intPageNumber, int p_intPageSize)
      {
          return GetModelList(p_strWhere, "", p_intPageNumber, p_intPageSize);
      }

      /// <summary>
      /// 得到对象集合
      /// </summary>
      public RESULT_BRAKE[] GetModelList()
      {
          return GetModelList("", "", -1, -1);
      }

      /// <summary>
      /// 得到对象集合
      /// </summary>
      public void GetModelList(ref DataTable p_dtData, string p_strWhere, string p_strOrder, int p_intPageNumber, int p_intPageSize)
      {
          p_dtData.Clear();

          int m_intPageNumber = p_intPageNumber;
          int m_intPageCount = GetPageCount(p_strWhere, p_intPageSize);

          if((m_intPageNumber < 1) || (m_intPageNumber == 0))
          {
              m_intPageNumber = 1;
          }

          if(m_intPageNumber == -1)
          {
              m_intPageNumber = m_intPageCount;
          }

          if(m_intPageNumber > m_intPageCount)
          {
              m_intPageNumber = m_intPageCount;
          }

          string strSql = "";
          strSql += "select * from RESULT_BRAKE";
          if(p_strWhere.Trim().Length > 0)
          {
              strSql += " where " + p_strWhere;
          }
          if(p_strOrder.Trim().Length > 0)
          {
              strSql += " order by " + p_strOrder;
          }

          if(p_intPageSize > 0)
          {
              DbHelper.GetTable(strSql, ref p_dtData, (m_intPageNumber-1)*p_intPageSize, p_intPageSize);
          }
          else
          {
              DbHelper.GetTable(strSql, ref p_dtData);
          }
       }

       /// <summary>
       /// 得到对象集合
       /// </summary>
       public void GetModelList(ref DataTable p_dtData, string p_strWhere)
       {
           GetModelList(ref p_dtData, p_strWhere, "", -1, -1);
       }

       /// <summary>
       /// 得到对象集合
       /// </summary>
       public void GetModelList(ref DataTable p_dtData, string p_strWhere, string p_strOrder)
       {
           GetModelList(ref p_dtData, p_strWhere, p_strOrder, -1, -1);
       }

       /// <summary>
       /// 得到对象集合
       /// </summary>
       public void GetModelList(ref DataTable p_dtData, int p_intPageNumber, int p_intPageSize)
       {
           GetModelList(ref p_dtData, "", "", p_intPageNumber, p_intPageSize);
       }

       /// <summary>
       /// 得到对象集合
       /// </summary>
       public void GetModelList(ref DataTable p_dtData, string p_strWhere, int p_intPageNumber, int p_intPageSize)
       {
           GetModelList(ref p_dtData, p_strWhere, "", p_intPageNumber, p_intPageSize);
       }
       /// <summary>
       /// 得到对象集合
       /// </summary>
       public void GetModelList(ref DataTable p_dtData)
       {
           GetModelList(ref p_dtData, "", "", -1, -1);
       }
   }
}
